10:07:17 WARNING Column type timestamp without time zone not supported for conversion from redshift to looker. No dimension will be created.
10:07:17 WARNING Column type boolean not supported for conversion from redshift to looker. No dimension will be created.
10:07:17 WARNING Column type double precision not supported for conversion from redshift to looker. No dimension will be created.
10:07:17 WARNING Column type character varying(108) not supported for conversion from redshift to looker. No dimension will be created.
10:07:17 DEBUG  Created view from model dim_appointment with 0 measures, 0 dimensions

Traceback (most recent call last):
File "/Users/username/Projects/dbt/dbt2looker-venv/bin/dbt2looker", line 5, in <module>
from dbt2looker.cli import run
File "/Users/username/Projects/dbt/dbt2looker-venv/lib/python3.11/site-packages/dbt2looker/cli.py", line 18, in <module>
from . import parser
File "/Users/username/Projects/dbt/dbt2looker-venv/lib/python3.11/site-packages/dbt2looker/parser.py", line 5, in <module>
from . import models
File "/Users/username/Projects/dbt/dbt2looker-venv/lib/python3.11/site-packages/dbt2looker/models.py", line 7, in <module>
from pydantic import BaseModel, Field, PydanticValueError, validator
ImportError: cannot import name 'PydanticValueError' from 'pydantic' (/Users/username/Projects/dbt/dbt2looker-venv/lib/python3.11/site-packages/pydantic/init.py)

❯ dbt2looker
12:11:54 ERROR  Cannot parse model with id: "model.smallpdf.brz_exchange_rates" - is the model file empty?
Failed

def lookml_dimensions_from_model(model: models.DbtModel, adapter_type: models.SupportedDbtAdapters):
    return [
        {
            'name': column.name,
            'type': map_adapter_type_to_looker(adapter_type, column.data_type),
            'sql': f'${{TABLE}}.{column.name}',
            'description': column.description
            'filter':[measure.name: f'measure.value']

        }
        for column in model.columns.values()
        for filter in column.meta.looker.filters
        if map_adapter_type_to_looker(adapter_type, column.data_type) in looker_scalar_types
    ]


def lookml_measures_from_model(model: models.DbtModel):
    return [
        {
            'name': measure.name,
            'type': measure.type.value,
            'sql': f'${{TABLE}}.{column.name}',
            'description': f'{measure.type.value.capitalize()} of {column.description}',
            **'filter':[measure.name: f'measure.value']**
        }
        for column in model.columns.values()
        for measure in column.meta.looker.measures
        **for filter in column.meta.looker.filters**

    ]

  measure: Page views {
    type: count
    sql: ${TABLE}.relevant_field ;;
    description: "Count of something."
    filter: [the_name_of_defined_column: value_of_defined_column]
  }

"model.zivver_dwh.crm_account_became_customer_dates":
        {
            "raw_sql": "WITH sfdc_accounts AS (\r\n\r\n    SELECT * FROM {{ ref('stg_sfdc_accounts') }}\r\n\r\n), crm_opportunities AS (\r\n\r\n    SELECT * FROM {{ ref('crm_opportunities') }}\r\n\r\n), crm_account_lifecycle_stage_changes_into_customer_observed AS (\r\n\r\n    SELECT\r\n        *\r\n    FROM {{ ref('crm_account_lifecycle_stage_changes_observed') }}\r\n    WHERE\r\n        new_stage = 'CUSTOMER'\r\n\r\n), became_customer_dates_from_opportunities AS (\r\n\r\n    SELECT\r\n        crm_account_id AS sfdc_account_id,\r\n\r\n        -- An account might have multiple opportunities. The account became customer when the first one was closed won.\r\n        MIN(closed_at) AS became_customer_at\r\n    FROM crm_opportunities\r\n    WHERE\r\n        opportunity_stage = 'CLOSED_WON'\r\n    GROUP BY\r\n        1\r\n\r\n), became_customer_dates_observed AS (\r\n\r\n    -- Some accounts might not have closed won opportunities, but still be a customer. Examples would be Connect4Care\r\n    -- customers, which have a single opportunity which applies to multiple accounts. If an account is manually set\r\n    -- to customer, this should also count as a customer.\r\n    --\r\n    -- We try to get the date at which they became a customer from the property history. Since that wasn't on from\r\n    -- the beginning, we conservatively default to either the creation date of the account or the history tracking\r\n    -- start date, whichever was earlier. Please note that this case should be exceedingly rare.\r\n    SELECT\r\n        sfdc_accounts.sfdc_account_id,\r\n        CASE\r\n            WHEN {{ var('date:sfdc:account_history_tracking:start_date') }} <= sfdc_accounts.created_at\r\n                THEN sfdc_accounts.created_at\r\n            ELSE {{ var('date:sfdc:account_history_tracking:start_date') }}\r\n        END AS default_became_customer_date,\r\n\r\n        COALESCE(\r\n            MIN(crm_account_lifecycle_stage_changes_into_customer_observed.new_stage_entered_at),\r\n            default_became_customer_date\r\n        ) AS became_customer_at\r\n\r\n    FROM sfdc_accounts\r\n    LEFT JOIN crm_account_lifecycle_stage_changes_into_customer_observed\r\n        ON sfdc_accounts.sfdc_account_id = crm_account_lifecycle_stage_changes_into_customer_observed.sfdc_account_id\r\n    WHERE\r\n        sfdc_accounts.lifecycle_stage = 'CUSTOMER'\r\n    GROUP BY\r\n        1,\r\n        2\r\n\r\n)\r\nSELECT\r\n    COALESCE(became_customer_dates_from_opportunities.sfdc_account_id,\r\n        became_customer_dates_observed.sfdc_account_id) AS sfdc_account_id,\r\n    COALESCE(became_customer_dates_from_opportunities.became_customer_at,\r\n        became_customer_dates_observed.became_customer_at) AS became_customer_at\r\nFROM became_customer_dates_from_opportunities\r\nFULL OUTER JOIN became_customer_dates_observed\r\n    ON became_customer_dates_from_opportunities.sfdc_account_id = became_customer_dates_observed.sfdc_account_id",
            "resource_type": "model",
            "depends_on":
            {
                "macros":
                [
                    "macro.zivver_dwh.ref",
                    "macro.zivver_dwh.audit_model_deployment_started",
                    "macro.zivver_dwh.audit_model_deployment_completed",
                    "macro.zivver_dwh.grant_read_rights_to_role"
                ],
                "nodes":
                [
                    "model.zivver_dwh.stg_sfdc_accounts",
                    "model.zivver_dwh.crm_opportunities",
                    "model.zivver_dwh.crm_account_lifecycle_stage_changes_observed"
                ]
            },
            "config":
            {
                "enabled": true,
                "materialized": "ephemeral",
                "persist_docs":
                {},
                "vars":
                {},
                "quoting":
                {},
                "column_types":
                {},
                "alias": null,
                "schema": "bl",
                "database": null,
                "tags":
                [
                    "business_layer",
                    "commercial"
                ],
                "full_refresh": null,
                "crm_record_types": null,
                "post-hook":
                [
                    {
                        "sql": "{{ audit_model_deployment_completed() }}",
                        "transaction": true,
                        "index": null
                    },
                    {
                        "sql": "{{ grant_read_rights_to_role('data_engineer', ['all']) }}",
                        "transaction": true,
                        "index": null
                    },
                    {
                        "sql": "{{ grant_read_rights_to_role('analyst', ['all']) }}",
                        "transaction": true,
                        "index": null
                    }
                ],
                "pre-hook":
                [
                    {
                        "sql": "{{ audit_model_deployment_started() }}",
                        "transaction": true,
                        "index": null
                    }
                ]
            },
            "database": "analytics",
            "schema": "bl",
            "fqn":
            [
                "zivver_dwh",
                "business_layer",
                "commercial",
                "crm_account_lifecycle_stage_changes",
                "intermediates",
                "crm_account_became_customer_dates",
                "crm_account_became_customer_dates"
            ],
            "unique_id": "model.zivver_dwh.crm_account_became_customer_dates",
            "package_name": "zivver_dwh",
            "root_path": "C:\\Users\\tjebbe.bodewes\\Documents\\zivver-dwh\\dwh\\transformations",
            "path": "business_layer\\commercial\\crm_account_lifecycle_stage_changes\\intermediates\\crm_account_became_customer_dates\\crm_account_became_customer_dates.sql",
            "original_file_path": "models\\business_layer\\commercial\\crm_account_lifecycle_stage_changes\\intermediates\\crm_account_became_customer_dates\\crm_account_became_customer_dates.sql",
            "name": "crm_account_became_customer_dates",
            "alias": "crm_account_became_customer_dates",
            "checksum":
            {
                "name": "sha256",
                "checksum": "a037b5681219d90f8bf8d81641d3587f899501358664b8ec77168901b3e1808b"
            },
            "tags":
            [
                "business_layer",
                "commercial"
            ],
            "refs":
            [
                [
                    "stg_sfdc_accounts"
                ],
                [
                    "crm_opportunities"
                ],
                [
                    "crm_account_lifecycle_stage_changes_observed"
                ]
            ],
            "sources":
            [],
            "description": "",
            "columns":
            {
                "sfdc_account_id":
                {
                    "name": "sfdc_account_id",
                    "description": "",
                    "meta":
                    {},
                    "data_type": null,
                    "quote": null,
                    "tags":
                    []
                },
                "became_customer_at":
                {
                    "name": "became_customer_at",
                    "description": "",
                    "meta":
                    {},
                    "data_type": null,
                    "quote": null,
                    "tags":
                    []
                }
            },
            "meta":
            {},
            "docs":
            {
                "show": true
            },
            "patch_path": "zivver_dwh://models\\business_layer\\commercial\\crm_account_lifecycle_stage_changes\\intermediates\\crm_account_became_customer_dates\\crm_account_became_customer_dates.yml",
            "compiled_path": null,
            "build_path": null,
            "deferred": false,
            "unrendered_config":
            {
                "pre-hook":
                [
                    "{{ audit_model_deployment_started() }}"
                ],
                "post-hook":
                [
                    "{{ grant_read_rights_to_role('analyst', ['all']) }}"
                ],
                "tags":
                [
                    "commercial"
                ],
                "materialized": "ephemeral",
                "schema": "bl",
                "crm_record_types": null
            },
            "created_at": 1637233875
        }

        - name: NewCustPromoCost_USD
          description: "Total customers Promo Type Cost in USD."
          meta:
           measures:
             NewCustPromoCost_USD:
               type: sum
           dimension:
            enabled: false

models:
  - name: ubie_jp_lake__dm_medico__hourly_score_for_nps
    description: |
      {{ doc("ubie_jp_lake__dm_medico__hourly_score_for_nps") }}
    meta:
      measures:
        total_x_y_z:
          type: number
          description: 'Summation of total x, total y and total z'
          sql: '${total_x} + ${total_y} + ${total_z}'

dbt2looker --tag test

$ dbt2looker --tag test
19:31:20 WARNING Multiple manifest.json files found in path ./ this can lead to unexpected behaviour
19:31:20 WARNING Multiple catalog.json files found in path ./ this can lead to unexpected behaviour
19:31:20 WARNING Multiple dbt_project.yml files found in path ./ this can lead to unexpected behaviour
19:31:20 INFO   Generated 0 lookml views in ./lookml/views
19:31:20 INFO   Generated 1 lookml model in ./lookml
19:31:20 INFO   Success

11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.relationships_stg_production__configuration_organization_id__organization_id__ref_stg_production__organization_.12c6be697f: Additional properties are not allowed ('metrics' was unexpected)
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.relationships_stg_production__configuration_organization_id__organization_id__ref_stg_production__organization_.12c6be697f: Additional properties are not allowed ('metrics', 'test_metadata', 'column_name', 'file_key_name' were unexpected)
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.relationships_stg_production__configuration_organization_id__organization_id__ref_stg_production__organization_.12c6be697f.resource_type: 'test' is not one of ['seed']
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.relationships_stg_production__configuration_organization_id__organization_id__ref_stg_production__organization_.12c6be697f: Additional properties are not allowed ('metrics', 'test_metadata', 'column_name', 'file_key_name' were unexpected)
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.relationships_stg_production__configuration_organization_id__organization_id__ref_stg_production__organization_.12c6be697f.resource_type: 'test' is not one of ['snapshot']
11:24:05 ERROR  Error in manifest at nodes.test.dbt_id_verification_analytics.relationships_stg_production__configuration_organization_id__organization_id__ref_stg_production__organization_.12c6be697f.resource_type: 'test' is not one of ['snapshot']
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.not_null_int_identifications_missed_sla_technical_time_in_seconds.8f9662f569: Additional properties are not allowed ('metrics', 'test_metadata', 'column_name', 'file_key_name' were unexpected)
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.not_null_int_identifications_missed_sla_technical_time_in_seconds.8f9662f569.resource_type: 'test' is not one of ['analysis']
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.not_null_int_identifications_missed_sla_technical_time_in_seconds.8f9662f569: 'compiled' is a required property
11:24:05 ERROR    Error in manifest at nodes.test.dbt_id_verification_analytics.not_null_int_identifications_missed_sla_technical_time_in_seconds.8f9662f569: Additional properties are not allowed ('metrics', 'test_metadata', 'column_name', 'file_key_name' were unexpected)

dbt docs generate
dbt2looker

dbt2looker 0.9.2 requires typing-extensions<4.0.0,>=3.10.0, but you have typing-extensions 4.3.0 which is incompatible.