Have gone through various answers and understand to create the table. but my issue is different.
We run same code for our 3 different business markets (or here we can say different schema).
For other 2 markets same ETL and storage loader works just fine without any error, inspite not having table
But for just one of the market/schema it’s throwing error
ERROR: Cannot COPY into nonexistent table com_snowplowanalytics_mobile_application_1
And resulting in storage load failure.
Not sure how and where to look for it. Didn’t even understand the problem correctly as it’s the same code/sql/etl/storage loader runs for all 3 schema.just that schema is different, everything is same.
please help and TIA