I am facing issue with Practical Exercises - Level 1. I am using free trial account for evaluation and using Matillion hosted agent. Snowflake is matillion provided in this case.
Specifically, to bring data from mariadb (as per exercise) i need to provide AWS password key for customers table and other information for the component. As information provided is missing I cant create the key.
I also do not know the warehouse name, database name,, schema name and any other credential to use further as these were created by Matillion.
I also do not see more components like Split flow, table update etc.. I raised a ticket but it takes time. My waiting time is high and my productive time on free trial account is reduced so will get less chance to work on it
Hi @binita.s1979
When using the Matillion hosted agent, you can create a secret and we'll manage it for you. You just have to go the the project panel and create a secret with the password you are specifying.
For the warehouse and schema, you can use the default ones. We also give you the database name as part of the instructions. We have most of the transformations components already. The ones missing will be prioritized accordingly and added to the product when ready.
Hope that helps.
Cheers,
Chika
I see exercise 1 video and content are modified and both options are included now. Will check further and revert. Thanks for these..
The part related to Database query and defining secret in exercise 1 is resolved. Thanks for it!
Now the next part is related to creating tables script "snowflake_create_tables_script_b27c6e.sql". Here my script, after replacing the db, table etc isnt working. I do not now what the correct values for the data warehouse, database, schema, source database, source schema are. Can you pls guide me?
FYI- The trial version is Matillion hosted agent.
Hi! In case you were still looking for the answer: The database name in a Matillion generated Snowflake acocunt is the same as the username it created, which you can find in your project environment (project -> environments -> ... -> Edit environment). If you want to verify this, using the create table tool will present you with a drop down menu to select the database. This seems indeed not mentioned anywhere in the tutorial, video or notes.