Compare commits

...

3 Commits

Author SHA1 Message Date
Jeremy Cohen
6cb599711d updates 2022-03-10 23:50:44 -05:00
Jeremy Cohen
0d4b6facd7 Add sample project, more printing 2022-03-10 22:53:18 -05:00
Jeremy Cohen
c4b75a22e0 Print cache timing 2022-03-10 12:34:20 -05:00
1504 changed files with 22945 additions and 2 deletions

View File

@@ -351,12 +351,15 @@ class BaseAdapter(metaclass=AdapterMeta):
self.list_relations_without_caching,
cache_schema,
)
print(f"Planning to cache schema {cache_schema.schema}", f"in database {cache_schema.database}" if cache_schema.database else "")
futures.append(fut)
for future in as_completed(futures):
results = future.result()
print(f"Added {len(results)} relations")
# if we can't read the relations we need to just raise anyway,
# so just call future.result() and let that raise on failure
for relation in future.result():
for relation in results:
self.cache.add(relation)
# it's possible that there were no relations in some schemas. We want

View File

@@ -54,7 +54,7 @@ from dbt.parser.manifest import ManifestLoader
import dbt.exceptions
from dbt import flags
import dbt.utils
from dbt.ui import warning_tag
from dbt.ui import warning_tag, green
RESULT_FILE_NAME = "run_results.json"
MANIFEST_FILE_NAME = "manifest.json"
@@ -391,7 +391,13 @@ class GraphRunnableTask(ManifestTask):
self._skipped_children[dep_node_id] = cause
def populate_adapter_cache(self, adapter):
import time
start = time.time()
print("Starting cache population")
adapter.set_relations_cache(self.manifest)
end = time.time()
print("Finished cache population")
print(green(end - start))
def before_hooks(self, adapter):
pass

View File

@@ -0,0 +1,33 @@
# Name your package! Package names should contain only lowercase characters
# and underscores. A good package name should reflect your organization's
# name or the intended use of these models
name: 'my_new_package'
version: 1.0.0
config-version: 2
# This setting configures which "profile" dbt uses for this project. Profiles contain
# database connection information, and should be configured in the ~/.dbt/profiles.yml file
profile: 'integration_tests'
# These configurations specify where dbt should look for different types of files.
# The `model-paths` config, for example, states that source models can be found
# in the "models/" directory. You probably won't need to change these!
model-paths: ["models"]
analysis-paths: ["analyses"]
test-paths: ["tests"]
seed-paths: ["seeds"]
macro-paths: ["macros"]
target-path: "target" # directory which will store compiled SQL files
clean-targets: # directories to be removed by `dbt clean`
- "target"
- "dbt_packages"
# You can define configurations for models in the `model-paths` directory here.
# Using these configurations, you can enable or disable models, change how they
# are materialized, and more!
# In this example config, we tell dbt to build all models in the example/ directory
# as views (the default). These settings can be overridden in the individual model files
# using the `{{ config(...) }}` macro.

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema6',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb2' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb3' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema3',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb0' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema2',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema0',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema5',
materialized='view'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb1' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema1',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

View File

@@ -0,0 +1,12 @@
{{
config(
enabled=var('add_noise', False),
database=('bigdb4' if target.type in ('snowflake', 'bigquery') else target.get('database')),
schema='bigschema4',
materialized='table'
)
}}
select 1 as fun, 'blue' as hue, true as is_cool, '2022-01-01' as date_day

Some files were not shown because too many files have changed in this diff Show More