Skip to main content

Tips and Troubleshooting

With any complex configuration such as SOLE, things will go wrong from time to time. Don't worry, we have you covered with handy tips and troubleshooting information.

Your first port of call for this should be the Operational Hints and Tips in the SOLE documentation.

For specific database objects, we have detailed documentation on each supported object type. Start with Account and use the sidebar menu to browse the other configurable objects.

Help!

If you don't find the information you need there, please let our support team know.

State Reset

One particular issue which may arise from time to time is a loss of sync between your SOLE configuration and Snowflake. Often occurring in development environments where configuration changes come thick and fast, this issue is not usually a big problem, as there's a simple fix: reset the state.

As discussed in previous sections, SOLE uses Terraform to manage some of the interactions with Snowflake, and Terraform uses a state file as part of that process, keeping a record of object configurations between pipeline runs. However, SOLE always scans the Snowflake database before making any changes, so if we have any issues the state can usually be safely reset

To perform a state reset, simply run your SOLE pipeline in the affected environment with the variable LIFECYCLE_STATE_RESET set to 1. This will tell SOLE to drop the Terraform state file and rebuild it.

For more information, see the SOLE documentation on state reset.

Debug

If you encounter pipeline errors, and the solution is not immediately obvious, you can re-run the pipeline with the variable DATAOPS_DEBUG set to 1. This will output additional debug information into the job logs.