How to build a calendar DIM_DATE table in Bigquery without using any source table?

404

nVector

posted on 16 Sep 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Post Comment

nVector16-Sep-20

Hello @RamyaG i have edited your question with more context and added the solution as well

ReplyMore..ReportDelete

RamyaG16-Sep-20

Hello @npack thanks Is it possible to build a calendar stage date table as same as above one

ReplyMore..ReportDelete

nVector16-Sep-20

What do you mean by Calendar Stage? If its just the table name, you can change the name of the table in the above script

ReplyMore..ReportDelete

RamyaG17-Sep-20

Hi @npack Can I get your email id or any chat box to have a live conversation with you because i need help from you regarding query converting snowflake to bigquery I'm struggling to convert them.

ReplyMore..ReportDelete

nVector17-Sep-20

@RamyaG I have sent an email to your registered email

ReplyMore..ReportDelete