Infoworks 6.1.3
Onboard Data
Documentation for Versions 2.x, 3.1.
Introduction
Additional Functionalities
RDBMS Ingestion
File Ingestion
Application Ingestion
Generic JDBC
STREAMING INGESTION
Metadata Sync
Additional Connectors

Editing Table Schema

You can edit the target datatype of columns using the following steps:

  1. Click the Data Catalog menu and click View Source for the required source.

  2. Click the Configure button for the required table.

  3. Click the View Details button and edit the target data type for required columns. The Databricks metastore table will be created with the specified datatypes.

  4. The Options field allows you to edit the precision and scale of the specific column.
  1. You can use the Bulk Edit option to edit the precision and scale of all the columns.
  1. Click Save Schema.

Following are the datatype conversions supported:

Source DatatypeTarget Datatype
StringBoolean, Integer, Float, Double, Long, Decimal, Date, Timestamp.Following are date and timestamp formats supported:Date: yyyy-MM-ddTimestamp: yy-MM-dd hh:mm:ss
BooleanString
IntegerFloat, Double, Long, Decimal, String
FloatDouble, Long, Decimal, String
DoubleFloat, Long, Decimal, String
LongFloat, Double, Decimal, String
DecimalInteger, Float, Long, String
DateString
TimestampString
ByteString
Next to read:
Viewing Table Details

For more details, refer to our Knowledge Base and Best Practices!

For help, contact our support team!

© UNIPHORE TECHNOLOGIES 2025 | Confidential

On This Page
Editing Table Schema