# Database Schema: Sandbox vs. Production **URL:** \ **Category:** Integrator.io\ **Created:** [September 9, 2025, 6:43pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425 "2025-09-09T18:43:49Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Sean\_Ayotte](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@Sean\_Ayotte](https://connective.celigo.com/u/Sean_Ayotte)\ **Post date:** [September 9, 2025, 6:43pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/1 "2025-09-09T18:43:49Z")
I just did the Office Hours meeting and asked about how to use different schemas between Sandbox and Prod (for database Connections). For instance, I have a table called ipaas\_dev (for Sandbox) and ipaas (for Prod). I want a simple way that adds \_dev for sandbox. In the past I did this via Integration Settings, and it worked for one upload, but then it wouldn’t work after that (I don’t recall the error but it made me start over). Regardless, the suggestion from Office Hours was to add this to the Connection Custom Settings: ```json { "env": "_dev" } ``` Then refer to it as `FROM [ipaas{{{settings.connection.env}}}].[users]`. That works for Lookups, but for Imports when using “Use bulk insert SQL query (recommended)” at least, this throws an error (as if it is now looking for a temp table??): Cannot find column metadata for table #[coinsuigLIVE].[ipaas\_dev].[users] Not sure if there is a way around this? I have added/removed the square brackets, but that had no affect. Please advise and Thank you. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [September 10, 2025, 7:25pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/2 "2025-09-10T19:25:28Z")
I think that's only a preview error due to the handlebars not being evaluated prior to attempting to fetch table metadata for mapper. Can you verify it works fine for runtime? ---
**Author:** ![Sean\_Ayotte](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@Sean\_Ayotte](https://connective.celigo.com/u/Sean_Ayotte)\ **Post date:** [September 10, 2025, 7:54pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/3 "2025-09-10T19:54:44Z")
That error is what appears when it is run. It looks like it thinks it is a temp table, unless “#” means something else than I’m accustomed to … ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [September 10, 2025, 9:16pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/4 "2025-09-10T21:16:42Z")
Same thing works though if you just hardcode in `_dev`? ---
**Author:** ![Sean\_Ayotte](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@Sean\_Ayotte](https://connective.celigo.com/u/Sean_Ayotte)\ **Post date:** [September 10, 2025, 9:43pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/5 "2025-09-10T21:43:45Z")
Correct, I usually don’t have the data bracketed, but it works just fine with ipaas\_dev. … It’s like when it sees the {{{ it changes it’s MO. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [September 11, 2025, 12:05am UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/6 "2025-09-11T00:05:28Z")
I just tested in my environment and it's working fine. I'd suggest making a ticket so support can troubleshoot further. ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/301db55423dd068c0328ec7fe9ac2805389a2302.png) ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/6a84093fb83b1c62471f492a44a0fcbef95536c4.png) ---
**Author:** ![michaelgantt](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/michaelgantt/32/6666_2.png) [@michaelgantt](https://connective.celigo.com/u/michaelgantt)\ **Post date:** [September 11, 2025, 1:00am UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/7 "2025-09-11T01:00:57Z")
It works when previewing in the handlebars editor for us also. Were you able to get it to actually run the flow and work? ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [September 11, 2025, 2:04am UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/8 "2025-09-11T02:04:15Z")
Yeah it worked in preview and runtime for me. ---
**Author:** ![tarunsinghpande34](https://avatars.discourse-cdn.com/v4/letter/t/e56c9b/32.png) [@tarunsinghpande34](https://connective.celigo.com/u/tarunsinghpande34)\ **Post date:** [December 1, 2025, 2:20pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/9 "2025-12-01T14:20:18Z")
I’m getting this error when inserting data into a table in MS-SQL. The error says “Cannot find column metadata for table #[dbo].[United States Bakery$DSD Load Adjustment Staging]”. Is this thing still an issue? ---
**Author:** ![Sean\_Ayotte](https://avatars.discourse-cdn.com/v4/letter/s/9fc29f/32.png) [@Sean\_Ayotte](https://connective.celigo.com/u/Sean_Ayotte)\ **Post date:** [December 1, 2025, 2:48pm UTC](https://connective.celigo.com/t/database-schema-sandbox-vs-production/5425/10 "2025-12-01T14:48:16Z")
In order to get this working: 1. Connections → (Select/Create your connection) 2. Custom Settings → Launch form builder 3. Update form builder (This is what my form builder looks like) for form `_dev` in Sandbox and since my table has no suffix in Prod, the form name is blank in Prod: ```auto { "fieldMap": { "Product Title": { "id": "Environment", "name": "Environment", "type": "text", "label": "Environment", "helpText": "Environment", "required": false } } } ``` 4a. When referencing the table, if inside SQL: from `[ipaas{{{settings.connection.Environment}}}].[table_name]` (brackets are optional), this would give me `[ipaas_dev]` in Sandbox and `[ipaas]` in Prod. 4b. If this is a Destination table in Celigo, you CANNOT use brackets, mine looks like `databasename.ipaas{{{settings.connection.Environment}}}.table_name`you won’t be able to see anything in preview, etc. so I would suggest hardcoding it to set-up any Mapping and then changing it to the above option so you can see your actual table names. Is this a great solution? Not really. Does it work? Yes.