Skip to main content
To homepage To homepage
Question

Export SQL Logic for a Single Table (Joins, Custom Fields, Transformations)

  • August 5, 2026
  • 2 replies
  • 24 views
N
Starter

Hi all,

I'm currently rebuilding an existing TimeXtender solution in another system and need to rebuild a large number of ETL pipelines.

I'm wondering if there's an easy way to export the complete SQL logic for a single table, including things like:

  • Joins
  • Custom fields / calculated fields
  • Transformation logic
  • Lookup logic
  • Any generated SQL behind the table

My goal isn't to migrate the project itself, but rather to use the generated SQL as a reference.

Is there a built-in way to export or generate the full SQL for an individual table, or is there another recommended approach for this type of migration?

Have tried looking at the documentation export-option but I don’t think thats what Im looking for.

Thanks!

2 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi ​@nohikh 

Are you using TDI or 20.10?

May I ask which platform you are moving to, the reason for the move and are you moving the entire solution or just part of the solution to another platform?

Thanks

N
Starter
  • nohikh
  • Author
  • Starter
  • August 6, 2026

Hi ​@Christian Hauggaard 

20.10.

I am not moving to a another platform, just trying to rebuild a specific part of the solution (ETL pipeline) in Databricks

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • August 6, 2026

Hi ​@nohikh 

You can always look at the Cleansing procedure for a table. It is stored as a Stored Procedure on the Prepare instance database.

The cleansing procedure contain all updates made to a table when it is executed, so joins, lookups and similar.

If you have some custom code set up, it will be stored in the Transformation View.

The transfer part is generated on execution so it is not something you can locate beforehand.

Terms and ConditionsAccessibility statement