TSQL to Snowflake transpile

[teja71296]

While trying to conver the queries to Snowflake compatible.

1. The views or tables why am i not able to get create or replace? which will help in not causing a failure.
2. The Stored procedure in snowflake are different . could some one please help me to achieve this.
3. How can we print the parts of the query like columns or table names etc.. I tried to print but its not working as i might be doing wrong.

[georgesittas]

Hey,

1. I don't understand the question here
2. This is out of scope, stored procedures are not handled by SQLGlot
3. Check out https://github.com/tobymao/sqlglot/blob/main/posts/ast_primer.md

[teja71296]

Sorry for causing the confusion related to above question..

1. While we are trying to Translate the TSQL to Snowflake - The output statements are coming as "Create table" or "Create view". But Can we make the output to be modified as "Create or replace table" or "Create or replace view"? This will help me to successfully pass the statements even if the table already exists in Snowflake.

2. Thanks for the reply - But could you please guide me or help me on how i can achieve to get the query part from the TSQL procedure and prepare our own custom Snowflake Procedure. For Ex:-
   TSQL code -

CREATE PROCEDURE GetCustomerSpending
AS
BEGIN
-- Retrieve customer spending data
SELECT cd.id AS customer_id,
CONCAT(cd.last_name, cd.first_name) AS full_name,
SUM(pd.amount) AS amount_spent
FROM customer_data cd
LEFT JOIN payments_data pd ON cd.id = pd.id
GROUP BY cd.id, CONCAT(cd.last_name, cd.first_name)
ORDER BY amount_spent DESC;
END
;
-- I need to pull out the query part and modify it for Snowflake. Need help to bring the main part of the query & the proc name.

3. Thanks for the link. Will go through this and reply back here if still there is any doubts for me in printing the columns or table names before translating the query.

[georgesittas]

I'll answer these inline:

1. You'll need to modify the AST, look into the ast primer on how to do that. You'll have to set replace to True IIRC.
2. This is not trivial to achieve, you need to have a good understanding of the inner workings to do it. My advise is to look into existing code that handles generation/transpilation of AST nodes and study the AST primer.