-
Notifications
You must be signed in to change notification settings - Fork 1
Profile Customization Properties
dbaAlex edited this page Feb 14, 2013
·
4 revisions
This page lists all of the properties in the two customization spreadsheets found in the profile_customization folder.
- source_name - The unique name of the source (ex. MyApp)
- source_type - The type of database/file (ex. Oracle or csv)
- source_schema - The schema name of the database, if needed (ex. my_app)
- source_connection_name - The unique name of the source connection. This variable matches your database connection transformation script names. (ex. my_app)
- source_tunnel_script - If required to tunnel into your database, that script goes here
- source_name - The name of the source that the query is intended for (The source_name from Data Profile Source List).
- table_name - The name of the table the query is for (ex. If MyApp has a my_customer table, then 'my_customer'.)
- table_query_number - The unique number for the custom query. Number is manually incremented in the file.
- custom_query - The custom query to be used by the profiling tool (ex. SELECT col_1, col_2 FROM my_customer;)
- query_type - The two valid types of queries for custom use are 'profiling' and 'sanity'.