You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the agent creates the target if it does not exist already when you run the task.
You can create both managed and external tables.
You can create both managed and external tables for mappings in advanced mode.
To specify the target properties, perform the following tasks:
Select the Target transformation in the mapping.
To specify the target, click the
Target
tab.
Select the target connection.
For the target type, choose
Single Object
or
Parameter
.
Specify the target object or parameter.
To specify a target object, perform the following tasks:
Click
Select
and choose a target object. You can select an existing target object or create a new target object at runtime.
To create a target object at runtime, select
Create New at Runtime
.
Enter the name of the target table that you want to create in the
Object Name
field. Specify the table name in lowercase.
Enter the location of the target table data in the
Table Location
field.
The table location is relative to the data bucket or data filesystem name specified in the connection. External table is created if you specify the table location.
For unity catalog, you must specify a pre-existing table location to create a new target at runtime.
In the
Database Name
field, specify the Databricks database name.
The database name that you specify in the connection properties takes precedence.
If Database Name is not provided in the
Create Target
UI or in the
Database
connection attribute, then, the default database is used for creating a target irrespective of the database name provided in the SQL Warehouse JDBC URL.
Specify the
Table Properties
to optimize the table configuration settings. You can use table properties to tag tables with information that are not tracked by SQL queries. To see the list of table properties and table options, see the Databricks Delta documentation.
ASK INFAPreview
