SUBSTRING_INDEX() in Snowflake
What is the exact duplicate function of MySQL SUBSTRING_INDEX() in Snowflake??
snowflake-cloud-data-platform
Find all rows that have Non-ASCII in a specific column in SnowFlake
I’m trying to find all rows in my table that have Non-ASCII characters (one or more) in a specific column in Snowflake. I’ve tried to use the query below. Although, it didn’t give me the results I was looking for.
Write a join subquery within a select query
I have this query that works in a separate worksheet.
random sampling from a table
I have an original table
how to take the standard deviation and sum of a count(*) result column
I have a table as such:
SQL: Shift columns value to left if a NULL value
I have a table that looks like below, with possible nulls in initial columns. I am looking to shift the columns to left in case a null is found so that all the categories align together.
Connection pooling for external connections in Airflow
I am trying to find a way for connection pool management for external connections created in Airflow.
Airflow version : 2.1.0
Python Version : 3.9.5
Airflow DB : SQLite
External connections created : MySQL and Snowflake
Split a large json file into multiple smaller files
I have a large JSON file, about 5 million records and a file size of about 32GB, that I need to get loaded into our Snowflake Data Warehouse. I need to get this file broken up into chunks of about 200k records (about 1.25GB) per file. I’d like to do this in either Node.JS or Python for deployment to an AWS Lambda function, unfortunately I haven’t coded in either, yet. I have C# and a lot of SQL experience, and learning both node and python are on my to do list, so why not dive right in, right!?