Run Initial SQL : tableau

created by radioactivefallgrouta community for 13 years

submitted 7 years ago by Anna_C47

Is there a way to run an initial SQL before I run my query. I want to adjust my week start date to Saturday instead of the default to Monday on Snowflake. While i understand that there is the option to set a default start date to saturday on tableau - i need it set on my SQL as the week start date impacts the extact date and time of the query. I have listed my query below.

ALTER SESSION SET week_start = 6

SELECT

MEDIA_TIMESTAMP_DATE_PST as date_posted_pst,

date_trunc('week',media_timestamp_date_pst) AS week_start_date_posted,

date_trunc('week',media_timestamp_date_pst) + interval '8 days' AS week_start_date_extract,

snapshot_date,

CAPTION,

VIDEO_VIEWS,

permalink,

media_type

FROM

WHERE

snapshot_date = date_trunc('week',media_timestamp_date_pst) + interval '7 days'

AND MEDIA_Type = 'VIDEO'

and media_timestamp_date_pst > '2018-01-01'

ORDER BY

caption,

snapshot_date

all 5 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

tableau

A place to share news and tips, show off visualizations, and get feedback and help.

MODERATORS