Looking for Pre and Post Export SQL queries examples

[H369199]

Looking for Pre and Post Export SQL queries examples

[bstephens]

@H369199

A common use for these pre and post queries is to optimize for loading data into an existing table.  In this case, you would use these as follows to avoid the index overhead when inserting rows: 

• Pre SQL: drop indexes using SQL appropriate for your RDMBS
• Post SQL: create indexes using SQL appropriate for your RDMBS

You might also want to use Post SQL to update statistics on the table to which you added data in order to ensure performant queries: 

• SQL Server:  update statistics <tablename>
• Postgres: analyze <tablename>

Thanks,
Bill

[Melanie]

Pre-import SQL
Custom SQL that executes before an import. You can use the {user.name} macro for the Paxata user name. For example, for Microsoft SQL Server, add user impersonation using:

EXECUTE AS user = 'mydomain\${user.name}'

Post-import SQL
Custom SQL that executes after an import. You can use the {user.name} macro for the Paxata user name.
EXECUTE AS user = 'mydomain\${user.name}'

hope that helps, M.