I figured I could easily create a basic data dictionary of the schema my team is working out of. I currently have this:

Hi how would I sum the following by the JSON variant column attributes?

I have a Snowpark dataframe, that I would like to query (and join to other tables) using SQL.

I have this script written in sql server syntax, that uses an OUTER APPLY. Seen below:

I am working on a query in Snowflake and am wanting to create an alias for a column. I know you can do this in other languages but am not sure if snowflake supports this.

Snowflake sql scripts to identify the storage cost based on input file size/volume of file and Identify the computations credit utilization based on input file size/volume of file —- Example 1GB file how much credit utilization and storage cost

I have below table in Snowflake db.

I am trying to generate date and time between two records for a particular id for some reporting for hourly level. Idea is to bring any record that is even unchanged or changed at date and hourly basis.

I have a table in which there exists duplicate rows where the Product name is the same, but the value is different. I don’t care which value I keep, I just want to get rid of the duplicate row and keep one. I am using SNO-SQL.

I’m creating a model in Snowflake where I need to calculate a short fall in demand and supply in a particular region