Set master_view='master_'||split_part($table_pattern,'. The Pengliu 18-IN-1 Carbon Steel Snowflake Multi-Tool is the perfect choice for anyone looking for a handy and effective way to take essential tools. Var stmt = snowflake.createStatement().execute() PROCEDURE FOR EXECUTING THE OUTPUT OF THE UDF ABOVE create or replace procedure _view(TABLE_PATTERN varchar, START_MONTH varchar,END_MONTH varchar) Select listagg(statement, ' ') within group (order by month_id) as create_view_statement (select start_month::int + row_number() over (order by 1) - 1įrom table(generator(rowcount=> end_month::int - start_month::int + 1)))Ĭoncat('create or replace temporary view master_',Ĭase when month_id=end_month::int then ' ' else ' union all ' end)

SQL UDF FOR GENERATING A CREATE VIEW STATETEMENT create or replace function _view(table_pattern varchar, start_month varchar, end_month varchar) I am sharing a simplified version of what I actually have in the interest of keeping it representative of the tables I listed in my question. The separation of UDF and stored proc actually helps with that as you'd mostly need to tweak the SQL UDF. I work with tables following specific naming convention, so you might have to tweak this solution a little for your use case. I ended up creating a UDF that spits out a create view statement and a stored procedure that executes it to create a temporary view. Return rows + ' rows inserted into master_table_1_12.' īy the way, if you don't have any processing to do and just need to consolidate the tables, you can do something like this: insert into master_table_1_12 Modify as required: create or replace procedure FILL_MASTER_TABLE() Here's a stored procedure that will insert into master_table_1_12 from selects on table_1 through table_12. Are Snowflake Tasks something I could use for this? I couldn't find a fitting example from their documentation to code that up but, if anyone had success with that or with a Javascript based SP for a problem like this, please enlighten. Sure it saves some space on the console(compared to multiple inserts), but I still have to run it 12 times. Note: All monthly tables have a month_id column Set table_name=concat('table_',$month_id) Then use variables such that I can simply keep hitting the run button until it errors out with 'table_13 does not exist' set month_id=(select max(month_id) from master_table_1_12) + 1

Select * - * to keep it simple for this example The stainless steel snowflake multi-purpose tool is perfect for crafty people, travelers, or those who occasionally need. Plus, the original snowflake shape is really adorable. You get to have multiple uses in one little keychain. create temporary table master_table_1_12 as The 18-in-1 snowflake multi-tool is the best tool anyone can have. My current approach is to first create the master table with data from table_1. Table_12 - (only 12 in this instance but could be as many as 36) What I want to do is to combine these 12 tables into one without having to write 10-30 insert/union all statements table_1

SMALL SIZE - At 2.3 ounces and 2.5' diameter, this unique snowflake-shaped design is easy to carry and fits right on a keyring.Let's say I have the following monthly tables with table names formatted such that the number after the underscore refers to the month.

MULTI-TOOL - One Multi-Tool contains 18 different tools in 1.Get your Pengliu® 18-IN-1 Carbon Steel Snowflake Multi-Tool today! It is the perfect addition to your camping, outdoor, or everyday gear! The unique snowflake shape will make any outdoor enthusiast or military buff smile with appreciation. The lightweight, yet durable construction makes it the ideal companion when you need to survive outdoors or tackle an emergency repair job. Its small size makes it easy to carry in your pocket or hang from your keys. Originally designed as a snowboarding tool, it opens bottles, turns screws, fixes snowboards or bikes, cuts boxes, and much more. The Pengliu® 18-IN-1 Carbon Steel Snowflake Multi-Tool is the perfect choice for anyone looking for a handy and effective way to take essential tools wherever they go.

Snowflake multi tool original