Skip to content

Instantly share code, notes, and snippets.

@louisguitton

louisguitton/sql_queries_with_between_clause.json

Created February 4, 2021 18:55
Show Gist options
  • Save louisguitton/5783e9729112215802e8bb632e702a81 to your computer and use it in GitHub Desktop.
Save louisguitton/5783e9729112215802e8bb632e702a81 to your computer and use it in GitHub Desktop.
Download ZIP
output data of the sql_queries_with_between_clause fixture
Raw
sql_queries_with_between_clause.json
{
"models/staging/localytics/stg_localytics__users_retained.sql_1": {
"date_column": "\n birth_date ",
"left_bound": " dateadd('day',-370,'{{ env_var(\"EXECUTION_DATE\") }}'::date)\n ",
"right_bound": "'{{ env_var(\"EXECUTION_DATE\") }}'::date"
},
"models/staging/localytics/dim_localytics__users.sql_1": {
"date_column": " occurred_at ",
"left_bound": " dateadd('day', -2, '{{ env_var(\"EXECUTION_DATE\") }}') ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n"
},
"models/staging/localytics/stg_localytics__users_session_started.sql_1": {
"date_column": "\n date_at ",
"left_bound": " dateadd('day', -3, '{{ env_var(\"EXECUTION_DATE\") }}')\n ",
"right_bound": "'{{ env_var(\"EXECUTION_DATE\") }}'\n "
},
"models/staging/adjust_external/stg_adjust__user_installs.sql_1": {
"date_column": "\n installed_at ",
"left_bound": " dateadd(day,-2,'{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n"
},
"models/staging/cms/stg_cms__article_facts.sql_1": {
"date_column": " fi.created_at ",
"left_bound": " dateadd(day, -14, '{{ env_var(\"EXECUTION_DATE\") }}')\n ",
"right_bound": "dateadd(ms, -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n "
},
"models/staging/cms/stg_cms__article_facts.sql_2": {
"date_column": " fi.created_at ",
"left_bound": " dateadd(day, -14, '{{ env_var(\"EXECUTION_DATE\") }}')\n ",
"right_bound": "dateadd(ms, -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n "
},
"models/staging/cms/stg_cms__article_facts.sql_3": {
"date_column": "\n publish_date ",
"left_bound": " dateadd(day, -3, '{{ env_var(\"EXECUTION_DATE\") }}')\n ",
"right_bound": "'{{ env_var(\"EXECUTION_DATE\") }}'"
},
"models/staging/localytics_external/stg_localytics__users_match_viewed.sql_1": {
"date_column": "\n date_at ",
"left_bound": " dateadd('day',-3,'{{ env_var(\"EXECUTION_DATE\") }}') ",
"right_bound": "'{{ env_var(\"EXECUTION_DATE\") }}'\n "
},
"models/staging/localytics_external/dim_localytics__web_users.sql_1": {
"date_column": "\n occurred_at ",
"left_bound": " dateadd('day', -2, '{{ env_var(\"EXECUTION_DATE\") }}') ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n"
},
"models/marts/sales/intermediate/stg_tv_guide.sql_1": {
"date_column": "\n date_at ",
"left_bound": " dateadd('day',-3,'{{ env_var(\"EXECUTION_DATE\") }}'::date)\n ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)"
},
"models/marts/pigeon/daily_analytics/viz_web_traffic.sql_1": {
"date_column": "\n date_at ",
"left_bound": " dateadd('day',-29,'{{ env_var(\"EXECUTION_DATE\") }}')::date ",
"right_bound": "'{{ env_var(\"EXECUTION_DATE\") }}'\n"
},
"models/marts/pigeon/daily_analytics/viz_web_traffic.sql_2": {
"date_column": "\n date_at ",
"left_bound": " dateadd('day',-59,'{{ env_var(\"EXECUTION_DATE\") }}')::date\n ",
"right_bound": "dateadd('day',-29,'{{ env_var(\"EXECUTION_DATE\") }}')::date\n"
},
"models/marts/pigeon/club_report/viz_club_report__match_push_reach.sql_1": {
"date_column": "\n dim_matches.kickoff_at_utc ",
"left_bound": " dateadd(day,-30,'{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n "
},
"models/marts/pigeon/club_report/viz_club_report__match_metrics.sql_1": {
"date_column": "\n kickoff_at_utc ",
"left_bound": " dateadd(day,-30,'{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n "
},
"models/marts/datasets/ml-entities/test_set_tagging.sql_1": {
"date_column": "\n publish_date ",
"left_bound": " dateadd('day', -1 * 30, '{{ env_var(\"EXECUTION_DATE\") }}' :: date) ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1) and"
},
"models/marts/datasets/ml-entities/train_set_tagging.sql_1": {
"date_column": "\n publish_date ",
"left_bound": " dateadd('day', -6 * 30, '{{ env_var(\"EXECUTION_DATE\") }}' :: date) ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1) and"
},
"models/marts/datasets/content-catchup/push_audience.sql_1": {
"date_column": " date_at ",
"left_bound": " dateadd('day', -30, '{{ env_var(\"EXECUTION_DATE\") }}' :: date) ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n "
},
"models/marts/datasets/content-catchup/push_audience.sql_2": {
"date_column": " date_at ",
"left_bound": " dateadd('day', -30, '{{ env_var(\"EXECUTION_DATE\") }}' :: date) ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n "
},
"models/marts/matches/fct_matches__timeseries_metrics.sql_1": {
"date_column": "\n occurred_at ",
"left_bound": " dateadd(day,-2,'{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n "
},
"models/marts/newsroom/fct_content_coverage.sql_1": {
"date_column": " published_at ",
"left_bound": " date_trunc('week','{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,date_trunc('week','{{ env_var(\"EXECUTION_DATE\") }}'::date)+7)\n "
},
"models/marts/newsroom/fct_articles_performance.sql_1": {
"date_column": "\n read_at ",
"left_bound": " dateadd('day',-2,'{{ env_var(\"EXECUTION_DATE\") }}'::date)\n ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n"
},
"models/marts/newsroom/intermediate/stg_qualified_user_article_sessions.sql_1": {
"date_column": "\n date_at::date\n ",
"left_bound": " dateadd('day',-3,'{{ env_var(\"EXECUTION_DATE\") }}'::date)\n ",
"right_bound": "dateadd('ms', -1, '{{ env_var(\"EXECUTION_DATE\") }}' + 1)\n "
},
"models/marts/push/fct_push__send_performance.sql_1": {
"date_column": "\n date_at ",
"left_bound": " dateadd(day, -1, '{{ env_var(\"EXECUTION_DATE\") }}') ",
"right_bound": "dateadd(day, 1, '{{ env_var(\"EXECUTION_DATE\") }}')\n "
},
"models/marts/marketing/fct_user_acquisition.sql_1": {
"date_column": "\n installed_at ",
"left_bound": " dateadd(day,-2,'{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n "
},
"models/marts/base/fct_app_traffic_l30.sql_1": {
"date_column": "\n date_at ",
"left_bound": " dateadd('day',-29,'{{ env_var(\"EXECUTION_DATE\") }}') ",
"right_bound": "dateadd('ms',-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n "
},
"models/marts/base/fct_app_traffic_mtd.sql_1": {
"date_column": "\n date_at ",
"left_bound": " date_trunc('month',dateadd(day,-2,'{{ env_var(\"EXECUTION_DATE\") }}'))\n ",
"right_bound": "dateadd(day,-2,'{{ env_var(\"EXECUTION_DATE\") }}')\n "
},
"models/marts/base/fct_app_traffic_mtd.sql_2": {
"date_column": "\n date_at ",
"left_bound": " date_trunc('month',dateadd(day,-1,'{{ env_var(\"EXECUTION_DATE\") }}'))\n ",
"right_bound": "dateadd(day,-1,'{{ env_var(\"EXECUTION_DATE\") }}')\n "
},
"models/marts/base/fct_app_traffic_mtd.sql_3": {
"date_column": "\n date_at ",
"left_bound": " date_trunc('month',dateadd(day,-0,'{{ env_var(\"EXECUTION_DATE\") }}'))\n ",
"right_bound": "dateadd(day,-0,'{{ env_var(\"EXECUTION_DATE\") }}')\n "
},
"models/marts/consumer_web/fct_consumer_web__new_users_activation.sql_1": {
"date_column": "\n birth_date ",
"left_bound": " dateadd(day,-30,'{{ env_var(\"EXECUTION_DATE\") }}'::date) ",
"right_bound": "dateadd(ms,-1,'{{ env_var(\"EXECUTION_DATE\") }}'::date+1)\n"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment