AStrato Use of Variables in SQL Queries

JulioArriaga Member Posts: 3 Type 0

I want to ask for some help.

I want to select a value from a SQL table, and save the selected value as it is shown in the 1st line in the Snowflake Code Sample image below. And I want to use that variable as a table in a simple select query with some where filters (Snowflake Code Sample image).

The code works in SQL, however how do I save a variable from AStrato to apply it the 1st line of the image and then execute the 3rd line of the image.

Image. Snowflake Code Sample