Hi Lakshay,

Thanks for you answer. All following cells are slipped.

I made more tests and here are the infos about the steps (with generic names of view/path/table).

I create all these steps and make a Run all :

1/ I declare sql parameters, example "country" or "ab_test_id"

2/ I create a table my_database.my_table_${country}_ab_test_id_${ab_test_id}

This table is OK, I can display it when a make a simple :

SELECT * FROM my_database.my_table_${country}_ab_test_id_${ab_test_id}

3/ I have to create a temp view from this table

Just to be sure I make a :

DROP VIEW IF EXISTS my_temp_view

Then I create my temp view :

CREATE OR REPLACE TEMP VIEW my_temp_view AS

SELECT * FROM my_database.my_table_${country}_ab_test_id_${ab_test_id}

>> Status OK, no error message

4/ Then I want to display the temp view :

SELECT * FROM my_temp_view

>> Command skipped (as all the following cells)

If I manually relaunch this cell (SELECT * FROM my_temp_view), the content of the view is displayed, and if I manually execute all the following cells it works.

-------------------------------------

I have tried with a schedule job. I have the same behavior, but I have an explicit error message on the job screen :

[TABLE_OR_VIEW_NOT_FOUND] The table or view my_database.my_table__ab_test_id_ cannot be found. Verify the spelling and correctness of the schema and catalog.

If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.

But I don't understand, in the step 2/ I correctly see the content of my table so it is created and it exists with the parameters in the name.