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

404

nVector

posted on

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

nVector

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

ReplyMore..ReportDelete

RamyaG

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

ReplyMore..ReportDelete

nVector

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

RamyaG

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

nVector

@RamyaG I have sent an email to your registered email

ReplyMore..ReportDelete