Describe the bug
running command dbt docs generate
results in error:
Building catalog
Encountered an error while generating catalog: Database Error
000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
running command dbt build
or dbt test
results in schema test failures:
1 of 31 START test source_not_null_cora_accounts_id.................. [RUN]
16:31:37 | 1 of 31 ERROR source_not_null_cora_accounts_id....................... [ERROR in 0.77s]
Database Error in test source_not_null_cora_accounts_id (models\sources\cora\sources.yml)
000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
Prior to generating docs or tests, dbt compile
and dbt run
were successful.
(.venv-dbt) PS C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt> dbt run
Running with dbt=0.21.0
Found 8 models, 31 tests, 0 snapshots, 0 analyses, 363 macros, 0 operations, 0 seed files, 37 sources, 0 exposures
15:43:05 | Concurrency: 1 threads (target='local')
15:43:05 |
15:43:05 | 1 of 7 START view model zz_warners_cora.accounts_src................. [RUN]
15:43:06 | 1 of 7 OK created view model zz_warners_cora.accounts_src............ [SUCCESS 1 in 1.47s]
15:43:06 | 2 of 7 START view model zz_warners_orca.current_workflow_properties_src [RUN]
15:43:08 | 2 of 7 OK created view model zz_warners_orca.current_workflow_properties_src [SUCCESS 1 in 1.97s]
15:43:08 | 3 of 7 START view model zz_warners_orca.id_clones_src................ [RUN]
15:43:10 | 3 of 7 OK created view model zz_warners_orca.id_clones_src........... [SUCCESS 1 in 1.18s]
15:43:10 | 4 of 7 START view model zz_warners_orca.id_map_src................... [RUN]
15:43:11 | 4 of 7 OK created view model zz_warners_orca.id_map_src.............. [SUCCESS 1 in 1.54s]
15:43:11 | 5 of 7 START view model zz_warners_salesforce.account_src............ [RUN]
15:43:12 | 5 of 7 OK created view model zz_warners_salesforce.account_src....... [SUCCESS 1 in 1.11s]
15:43:12 | 6 of 7 START view model zz_warners_veeva.account_src................. [RUN]
15:43:14 | 6 of 7 OK created view model zz_warners_veeva.account_src............ [SUCCESS 1 in 1.37s]
15:43:14 | 7 of 7 START view model zz_warners_edm.account_dim................... [RUN]
15:43:15 | 7 of 7 OK created view model zz_warners_edm.account_dim.............. [SUCCESS 1 in 1.08s]
15:43:15 |
15:43:15 | Finished running 7 view models in 19.79s.
Steps To Reproduce
%USERPROFILE%/.dbt/profiles.yml
config:
send_anonymous_usage_stats: False
use_colors: True
dwm-core-snowflake:
target: local
outputs:
local:
type: snowflake
account: someaccount
user: someuser
authenticator: externalbrowser
role: snowflake_developer
warehouse: "DEVELOPER_WH"
#attempted with numerous variations of warehouse: quoted/not quoted lower/upper case
# user has a default role defined in snowflake with access to warehouse
database: raw_dev
schema: "zz_{{ env_var('USERNAME') }}"
threads: 1
query_tag: "{{ env_var('USERNAME') }}-dbt"
dbt_project.yml
...
#attempted with and without snowflake_warehouse
models:
+snowflake_warehouse: "DEVELOPER_WH"
dwm_core:
dims:
+schema: edm
+materialized: view
sources:
+database: raw_dev
+materialized: view
somesource:
+schema: someschema
Expected behavior
Expected docs to be generated without an error.
Expected get_catalog sql be run from a snowflake sql connection with the designated warehouse from profiles.yml
Screenshots and log output
dbt.log for dbt docs generate
2021-10-11 23:36:13.483636 (MainThread): Connection 'master' was properly closed.
2021-10-11 23:36:13.484632 (MainThread): Connection 'list_raw_dev_zz_warners_salesforce' was properly closed.
2021-10-11 23:36:13.484632 (MainThread): Connection 'test.dwm_core.unique_account_dim_unique_key.90cb7ab562' was properly closed.
2021-10-11 23:36:13.496631 (MainThread): 16:36:13 | Done.
2021-10-11 23:36:13.500634 (MainThread): Acquiring new snowflake connection "generate_catalog".
2021-10-11 23:36:13.501635 (MainThread): 16:36:13 | Building catalog
2021-10-11 23:36:13.518635 (ThreadPoolExecutor-1_0): Acquiring new snowflake connection "raw_dev.information_schema".
2021-10-11 23:36:13.534231 (ThreadPoolExecutor-1_0): Using snowflake connection "raw_dev.information_schema".
2021-10-11 23:36:13.534231 (ThreadPoolExecutor-1_0): On raw_dev.information_schema: /* {"app": "dbt", "dbt_version": "0.21.0", "profile_name": "dwm-core-snowflake", "target_name": "local", "connection_name": "raw_dev.information_schema"} */
with tables as (
select
table_catalog as "table_database",
table_schema as "table_schema",
table_name as "table_name",
table_type as "table_type",
comment as "table_comment",
-- note: this is the _role_ that owns the table
table_owner as "table_owner",
'Clustering Key' as "stats:clustering_key:label",
clustering_key as "stats:clustering_key:value",
'The key used to cluster this table' as "stats:clustering_key:description",
(clustering_key is not null) as "stats:clustering_key:include",
'Row Count' as "stats:row_count:label",
row_count as "stats:row_count:value",
'An approximate count of rows in this table' as "stats:row_count:description",
(row_count is not null) as "stats:row_count:include",
'Approximate Size' as "stats:bytes:label",
bytes as "stats:bytes:value",
'Approximate size of the table as reported by Snowflake' as "stats:bytes:description",
(bytes is not null) as "stats:bytes:include",
'Last Modified' as "stats:last_modified:label",
to_varchar(convert_timezone('UTC', last_altered), 'yyyy-mm-dd HH24:MI'||'UTC') as "stats:last_modified:value",
'The timestamp for last update/change' as "stats:last_modified:description",
(last_altered is not null and table_type='BASE TABLE') as "stats:last_modified:include"
from raw_dev.INFORMATION_SCHEMA.tables
),
columns as (
select
table_catalog as "table_database",
table_schema as "table_schema",
table_name as "table_name",
column_name as "column_name",
ordinal_position as "column_index",
data_type as "column_type",
comment as "column_comment"
from raw_dev.INFORMATION_SCHEMA.columns
)
select *
from tables
join columns using ("table_database", "table_schema", "table_name")
where (upper("table_schema") = upper('zz_warners_edm') or upper("table_schema") = upper('zz_warners_stage') or upper("table_schema") = upper('salesforce') or upper("table_schema") = upper('orca') or upper("table_schema") = upper('veeva') or upper("table_schema") = upper('zz_warners_cora') or upper("table_schema") = upper('zz_warners_veeva') or upper("table_schema") = upper('zz_warners_salesforce') or upper("table_schema") = upper('zz_warners_orca') or upper("table_schema") = upper('cora') or upper("table_schema") = upper('zz_warners_dbt_test__audit'))
order by "column_index"
2021-10-11 23:36:13.535231 (ThreadPoolExecutor-1_0): Opening a new connection, currently in state init
2021-10-11 23:36:14.481791 (ThreadPoolExecutor-1_0): Snowflake query id: 019f8be8-0000-8191-0000-8949001d781a
2021-10-11 23:36:14.481791 (ThreadPoolExecutor-1_0): Snowflake error: 000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
2021-10-11 23:36:14.482792 (ThreadPoolExecutor-1_0): Error running SQL: macro get_catalog
2021-10-11 23:36:14.482792 (ThreadPoolExecutor-1_0): Rolling back transaction.
2021-10-11 23:36:14.483791 (ThreadPoolExecutor-1_0): On raw_dev.information_schema: Close
2021-10-11 23:36:14.650833 (MainThread): Encountered an error while generating catalog: Database Error
000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
2021-10-11 23:36:14.683789 (MainThread): dbt encountered 1 failure while writing the catalog
2021-10-11 23:36:14.684785 (MainThread): 16:36:14 | Catalog written to C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\.dbt\.output\catalog.json
2021-10-11 23:36:14.689805 (MainThread): Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001AE68C09A30>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001AE72675A60>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001AE72675EE0>]}
2021-10-11 23:36:14.691847 (MainThread): Flushing usage events
2021-10-11 23:36:15.238732 (MainThread): Connection 'generate_catalog' was properly closed.
2021-10-11 23:36:15.238732 (MainThread): Connection 'raw_dev.information_schema' was properly closed.
dbt.log for running ```dbt test --select source:veeva
2021-10-11 23:41:59.778136 (Thread-1): Began running node test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d
2021-10-11 23:41:59.778136 (Thread-1): 16:41:59 | 2 of 2 START test source_not_null_veeva_account_id................... [RUN]
2021-10-11 23:41:59.780137 (Thread-1): Acquiring new snowflake connection "test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d".
2021-10-11 23:41:59.781162 (Thread-1): Compiling test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d
2021-10-11 23:41:59.790138 (Thread-1): Writing injected SQL for node "test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d"
2021-10-11 23:41:59.795134 (Thread-1): finished collecting timing info
2021-10-11 23:41:59.800177 (Thread-1): Writing runtime SQL for node "test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d"
2021-10-11 23:41:59.805134 (Thread-1): Using snowflake connection "test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d".
2021-10-11 23:41:59.806146 (Thread-1): On test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d: /* {"app": "dbt", "dbt_version": "0.21.0", "profile_name": "dwm-core-snowflake", "target_name": "local", "node_id": "test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d"} */
select
count(*) as failures,
count(*) != 0 as should_warn,
count(*) != 0 as should_error
from (
select *
from raw_dev.veeva.account
where id is null
) dbt_internal_test
2021-10-11 23:41:59.806146 (Thread-1): Opening a new connection, currently in state closed
2021-10-11 23:42:00.335136 (Thread-1): Snowflake query id: 019f8bee-0000-7eca-0000-8949001d6b2a
2021-10-11 23:42:00.336157 (Thread-1): Snowflake error: 000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
2021-10-11 23:42:00.336157 (Thread-1): finished collecting timing info
2021-10-11 23:42:00.337143 (Thread-1): On test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d: Close
2021-10-11 23:42:00.497138 (Thread-1): Database Error in test source_not_null_veeva_account_id (models\sources\veeva\sources.yml)
000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
compiled SQL at ../.dbt/.output\run\dwm_core\models\sources\veeva\sources.yml\schema_test\source_not_null_veeva_account_id.sql
Traceback (most recent call last):
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\snowflake\connections.py", line 183, in exception_handler
yield
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\sql\connections.py", line 80, in add_query
cursor.execute(sql, bindings)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\snowflake\connector\cursor.py", line 721, in execute
Error.errorhandler_wrapper(
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\snowflake\connector\errors.py", line 258, in errorhandler_wrapper
cursor.errorhandler(connection, cursor, error_class, error_value)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\snowflake\connector\errors.py", line 188, in default_errorhandler
raise error_class(
snowflake.connector.errors.ProgrammingError: 000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\task\base.py", line 348, in safe_run
result = self.compile_and_execute(manifest, ctx)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\task\base.py", line 291, in compile_and_execute
result = self.run(ctx.node, manifest)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\task\base.py", line 393, in run
return self.execute(compiled_node, manifest)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\task\test.py", line 112, in execute
result = self.execute_test(test, manifest)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\task\test.py", line 82, in execute_test
macro_func()
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\clients\jinja.py", line 333, in __call__
return self.call_macro(*args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\clients\jinja.py", line 260, in call_macro
return macro(*args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\runtime.py", line 675, in __call__
return self._invoke(arguments, autoescape)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\runtime.py", line 679, in _invoke
rv = self._func(*arguments)
File "<template>", line 132, in macro
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\sandbox.py", line 462, in call
return __context.call(__obj, *args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\runtime.py", line 290, in call
return __obj(*args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\clients\jinja.py", line 333, in __call__
return self.call_macro(*args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\clients\jinja.py", line 260, in call_macro
return macro(*args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\runtime.py", line 675, in __call__
return self._invoke(arguments, autoescape)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\runtime.py", line 679, in _invoke
rv = self._func(*arguments)
File "<template>", line 41, in macro
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\sandbox.py", line 462, in call
return __context.call(__obj, *args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\jinja2\runtime.py", line 290, in call
return __obj(*args, **kwargs)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\base\impl.py", line 226, in execute
return self.connections.execute(
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\sql\connections.py", line 131, in execute
_, cursor = self.add_query(sql, auto_begin)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\snowflake\connections.py", line 354, in add_query
connection, cursor = super().add_query(
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\sql\connections.py", line 87, in add_query
return connection, cursor
File "C:\Program Files\Python38\lib\contextlib.py", line 131, in __exit__
self.gen.throw(type, value, traceback)
File "C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt\lib\site-packages\dbt\adapters\snowflake\connections.py", line 200, in exception_handler
raise DatabaseException(msg)
dbt.exceptions.DatabaseException: Database Error in test source_not_null_veeva_account_id (models\sources\veeva\sources.yml)
000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
compiled SQL at ../.dbt/.output\run\dwm_core\models\sources\veeva\sources.yml\schema_test\source_not_null_veeva_account_id.sql
2021-10-11 23:42:00.499143 (Thread-1): 16:42:00 | 2 of 2 ERROR source_not_null_veeva_account_id........................ [ERROR in 0.72s]
2021-10-11 23:42:00.500138 (Thread-1): Finished running node test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d
2021-10-11 23:42:00.502136 (MainThread): Acquiring new snowflake connection "master".
2021-10-11 23:42:00.503140 (MainThread): 16:42:00 |
2021-10-11 23:42:00.504138 (MainThread): 16:42:00 | Finished running 2 tests in 5.55s.
2021-10-11 23:42:00.505136 (MainThread): Connection 'master' was properly closed.
2021-10-11 23:42:00.505136 (MainThread): Connection 'list_raw_dev_zz_warners_veeva' was properly closed.
2021-10-11 23:42:00.506138 (MainThread): Connection 'test.dwm_core.source_not_null_veeva_account_id.41a7bbc89d' was properly closed.
2021-10-11 23:42:00.550138 (MainThread):
2021-10-11 23:42:00.551139 (MainThread): Completed with 2 errors and 0 warnings:
2021-10-11 23:42:00.552157 (MainThread):
2021-10-11 23:42:00.553139 (MainThread): Database Error in test source_not_null_veeva_ab_site__c_id (models\sources\veeva\sources.yml)
2021-10-11 23:42:00.554137 (MainThread): 000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
2021-10-11 23:42:00.555137 (MainThread):
2021-10-11 23:42:00.556147 (MainThread): compiled SQL at ../.dbt/.output\run\dwm_core\models\sources\veeva\sources.yml\schema_test\source_not_null_veeva_ab_site__c_id.sql
2021-10-11 23:42:00.558145 (MainThread):
2021-10-11 23:42:00.560153 (MainThread): Database Error in test source_not_null_veeva_account_id (models\sources\veeva\sources.yml)
2021-10-11 23:42:00.565167 (MainThread): 000606 (57P03): No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
2021-10-11 23:42:00.566136 (MainThread):
2021-10-11 23:42:00.576140 (MainThread): compiled SQL at ../.dbt/.output\run\dwm_core\models\sources\veeva\sources.yml\schema_test\source_not_null_veeva_account_id.sql
2021-10-11 23:42:00.584148 (MainThread):
Done. PASS=0 WARN=0 ERROR=2 SKIP=0 TOTAL=2
2021-10-11 23:42:00.586156 (MainThread): Sending event: {'category': 'dbt', 'action': 'invocation', 'label': 'end', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001E3C7DB2F40>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001E3C7C9DE20>, <snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x000001E3C837FD00>]}
2021-10-11 23:42:00.588207 (MainThread): Flushing usage events
System information
Which database are you using dbt with?
The output of dbt --version
:
(.venv-dbt) PS C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt> dbt --version
installed version: 0.21.0
latest version: 0.21.0
Up to date!
Plugins:
- snowflake: 0.21.0
The operating system you're using:
Windows 10
The output of python --version
:
Python 3.8.10
Configurations attempted:
- (using jaffle_shop models)
Running with dbt=0.21.0
dbt version: 0.21.0
python version: 3.8.10
python path: C:\Users\warners\clients\adaptive\repos\vscode\dwm\dbt-debug\.venv\Scripts\python.exe
os info: Windows-10-10.0.19042-SP0
Using profiles.yml file at C:\Users\warners\.dbt\profiles.yml
Using dbt_project.yml file at C:\Users\warners\clients\adaptive\repos\vscode\dwm\dbt-debug\dwm_core\dbt_project.yml
Configuration:
profiles.yml file [OK found and valid]
dbt_project.yml file [OK found and valid]
Required dependencies:
- git [OK found]
Connection:
account: adaptivebiotech-corp
user: ELT_DEV
database: raw_dev
schema: zz_warners
warehouse: DEVELOPER_WH
role: SNOWFLAKE_DEVELOPER
client_session_keep_alive: False
Connection test: [OK connection ok]
All checks passed!
- dbt 18.2 with snowflake connector snowflake-connector-python 2.2.10
(.venv-dbt-0182) PS C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt> dbt debug
Running with dbt=0.18.2
dbt version: 0.18.2
python version: 3.8.10
python path: C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt-0182\Scripts\python.exe
os info: Windows-10-10.0.19042-SP0
Using profiles.yml file at C:\Users\warners\.dbt\profiles.yml
Using dbt_project.yml file at C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\dbt_project.yml
Configuration:
profiles.yml file [OK found and valid]
dbt_project.yml file [OK found and valid]
Required dependencies:
- git [OK found]
Connection:
account: adaptivebiotech-corp
user: ELT_DEV
database: raw_dev
schema: zz_warners
warehouse: DEVELOPER_WH
role: SNOWFLAKE_DEVELOPER
client_session_keep_alive: False
Connection test: OK connection ok
- dbt 19.2 with snowflake-connector-python 2.5.1
(.venv-dbt-0192-v2) PS C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt> dbt debug
Running with dbt=0.19.2
dbt version: 0.19.2
python version: 3.8.10
python path: C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt-0192-v2\Scripts\python.exe
os info: Windows-10-10.0.19042-SP0
Using profiles.yml file at C:\Users\warners\.dbt\profiles.yml
Using dbt_project.yml file at C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\dbt_project.yml
Configuration:
profiles.yml file [OK found and valid]
dbt_project.yml file [OK found and valid]
Required dependencies:
- git [OK found]
Connection:
account: adaptivebiotech-corp
user: ELT_DEV
database: raw_dev
schema: zz_warners
warehouse: DEVELOPER_WH
role: SNOWFLAKE_DEVELOPER
client_session_keep_alive: False
Connection test: OK connection ok
- dbt 1.0.0-b1 and snowflake-connector-python 2.5.1
(.venv-dbt-1b1) PS C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt> dbt debug
Running with dbt=1.0.0-b1
dbt version: 1.0.0-b1
python version: 3.8.10
python path: C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\.venv-dbt-1b1\Scripts\python.exe
os info: Windows-10-10.0.19042-SP0
Using profiles.yml file at C:\Users\warners\.dbt\profiles.yml
Using dbt_project.yml file at C:\Users\warners\clients\adaptive\repos\vscode\dwm\web-tools\dbt\dbt_project.yml
Configuration:
profiles.yml file [OK found and valid]
dbt_project.yml file [OK found and valid]
Required dependencies:
- git [OK found]
Connection:
account: adaptivebiotech-corp
user: ELT_DEV
database: raw_dev
schema: zz_warners
warehouse: DEVELOPER_WH
role: SNOWFLAKE_DEVELOPER
client_session_keep_alive: False
Connection test: [OK connection ok]