Skip to content

Instantly share code, notes, and snippets.

@oravi
Last active August 9, 2022 07:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oravi/1efcf594a9f1ec0504e47fd99111a122 to your computer and use it in GitHub Desktop.
Save oravi/1efcf594a9f1ec0504e47fd99111a122 to your computer and use it in GitHub Desktop.
{
"status": "success",
"timing":
[
{
"name": "compile",
"started_at": "2022-08-08T17:09:53.730220Z",
"completed_at": "2022-08-08T17:09:53.735205Z"
},
{
"name": "execute",
"started_at": "2022-08-08T17:09:53.735521Z",
"completed_at": "2022-08-08T17:09:54.419013Z"
}
],
"thread_id": "Thread-1",
"execution_time": 0.8850560188293457,
"adapter_response":
{
"_message": "SUCCESS 1",
"code": "SUCCESS",
"rows_affected": 1
},
"message": "SUCCESS 1",
"failures": null,
"node":
{
"compiled": true,
"resource_type": "model",
"depends_on":
{
"macros":
[
"macro.dbt_snowflake.set_query_tag",
"macro.dbt.create_or_replace_view",
"macro.dbt.persist_docs"
],
"nodes":
[
"seed.jaffle_shop.raw_customers"
]
},
"config":
{
"enabled": true,
"alias": null,
"schema": null,
"database": null,
"tags":
[],
"meta":
{},
"materialized": "view",
"incremental_strategy": null,
"persist_docs":
{},
"quoting":
{},
"column_types":
{},
"full_refresh": null,
"unique_key": null,
"on_schema_change": "ignore",
"grants":
{},
"packages":
[],
"post-hook":
[],
"pre-hook":
[]
},
"database": "elementary_db",
"schema": "jaffle_shop",
"fqn":
[
"jaffle_shop",
"staging",
"stg_customers"
],
"unique_id": "model.jaffle_shop.stg_customers",
"raw_code": "with source as (\n\n {#-\n Normally we would select from the table here, but we are using seeds to load\n our data in this project\n #}\n select * from {{ ref('raw_customers') }}\n\n),\n\nrenamed as (\n\n select\n id as customer_id,\n first_name,\n last_name\n\n from source\n\n)\n\nselect * from renamed",
"language": "sql",
"package_name": "jaffle_shop",
"root_path": "/Users/oravidov/workspace/jaffle_shop",
"path": "staging/stg_customers.sql",
"original_file_path": "models/staging/stg_customers.sql",
"name": "stg_customers",
"alias": "stg_customers",
"checksum":
{
"name": "sha256",
"checksum": "6f18a29204dad1de6dbb0c288144c4990742e0a1e065c3b2a67b5f98334c22ba"
},
"tags":
[],
"refs":
[
[
"raw_customers"
]
],
"sources":
[],
"metrics":
[],
"description": "",
"columns":
{
"customer_id":
{
"name": "customer_id",
"description": "",
"meta":
{},
"data_type": null,
"quote": null,
"tags":
[]
}
},
"meta":
{},
"docs":
{
"show": true
},
"patch_path": "jaffle_shop://models/staging/schema.yml",
"compiled_path": "target/compiled/jaffle_shop/models/staging/stg_customers.sql",
"build_path": "target/run/jaffle_shop/models/staging/stg_customers.sql",
"deferred": false,
"unrendered_config":
{
"materialized": "view"
},
"created_at": 1659978488.800274,
"config_call_dict":
{},
"compiled_code": "with source as (\n select * from elementary_db.jaffle_shop.raw_customers\n\n),\n\nrenamed as (\n\n select\n id as customer_id,\n first_name,\n last_name\n\n from source\n\n)\n\nselect * from renamed",
"extra_ctes_injected": true,
"extra_ctes":
[],
"relation_name": "elementary_db.jaffle_shop.stg_customers"
},
"agate_table": null
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment