FAQ

Can WriteBackExtreme run in docker / kubernetes?

Yes WriteBackExtreme can run in a container. The configuration for this is next-level since it needs to be configured manually without the one-click installer. Reach out to our support channel for the possibilities.

How to copy a schema to another database

WriteBackExtreme does not support transferring a schema to another database. The best option is to copy the table using the export/import function via management console and transfer the data itself using your own database management tool.

1. Open the management console.

2. Go to schemas and select the schema you want to copy

3. Click the export button at the top right. A json fill will be downloaded in your browser

4. Click Schemas in the menu again

5. Click the import button

6. Select the connection to the other database

7. Click import. The table will be created.

8. After this, export all data from your original table with your favorite database management tool and import it to the new table in the destination database table.

Since we made a copy, all dashboards need to be reconfigured using the new schema.

The easiest way to do this is trough the export/import functionality of the extension. This way your dashboard extension settings are preserved.

1. In the management console, open the schema.

   1. The url looks like this: https://[your-writebackextreme-url]/backend/schemas/84f7d654-f672-4e16-91fa-3b3d4c58c64b/

   2. The last part (excluding the / at the end) is the UUID of the new schema.

   3. Copy this UUID.

2. In your dashboard extension go to configuration

3. Select import/Export in the left menu

4. Click Download data file

5. Open the file in a text editor like notepad.

6. Search for the term schema_key in the file. The value should be a UUID (for example 9ab26ae5-5e5f-4142-ba6a-b61ac77f7a23)

7. Change the original UUID to the new one you copied from the management console.

8. Save the file

9. Go to the dashboard configuration again

10. Remove the old schema.

11. Import the data.json file you just edited on the import/Export page.

12. After importing you will see that the schema is added and all configuration is preserved.

Can WriteBackExtreme connect to snowflake with Key-Pair authentication?

Yes we can! This is possible via the ODBC settings in your system. Follow this tutorial to set it up: https://community.snowflake.com/s/article/How-to-set-up-ODBC-Driver-with-key-pair-authentication-to-connect-to-Snowflake-on-Windows

Does WriteBackExtreme lock tables

No, we do not lock tables while writing.