Data Types

Lists data types that you can apply data access policies to when using the Managed Access setting in a delivery template in Data Marketplace or with access policy transformations in Data Integration.

Azure SQL data types

The following table lists the data types that you can use with an Azure SQL data source when using access policy transformations in Data Integration:

Azure SQL data type	Data Access Management data type
bigint	integer
bit	integer
char	string
datetime	timestamp
datetime2	timestamp
datetimeoffset	timestamp
decimal	decimal
float	decimal
geography	unknown
geometry	unknown
hierarchyid	unknown
int	integer
money	decimal
nchar	string
ntext	string
numeric	decimal
nvarchar	string
smalldatetime	timestamp
smallint	integer
smallmoney	decimal
sql_variant	unknown
text	string
time	timestamp
tinyint	integer
uniqueidentifier	unknown
varchar	string
xml	unknown

Azure Synapse data types

The following table lists the data types that you can use with an Azure Synapse data source when using access policy transformations in Data Integration:

Azure Synapse data type	Data Access Management data type
bigint	integer
bit	integer
char	string
date	timestamp
datetime	timestamp
datetime2	timestamp
datetimeoffset	string
decimal	decimal
float	decimal
int	integer
money	decimal
nchar	string
numeric	decimal
nvarchar	string
real	decimal
smallint	integer
smallmoney	decimal
smalldatetime	timestamp
tinyint	integer
uniqueidentifier	string
varchar	string

Databricks Delta data types

The following table lists the data types that you can use with a Databricks Delta Lake data source when using access policy transformations in Data Integration:

Databricks Delta data type	Data Access Management data type
array	unknown
bigint	integer
char	string
date	date
decimal	decimal
double	decimal
float	decimal
int	integer
map	unknown
smallint	integer
string	string
struct	unknown
timestamp	timestamp
timestamp_ntz	timestamp
tinyint	integer

Microsoft SQL Server data types

The following table lists the data types that you can use with a Microsoft SQL Server data source when using the Managed Access setting in a delivery template in Data Marketplace and with access policy transformations in Data Integration:

Microsoft SQL Server data type	Data Access Management data type
bigint	integer
char	string
datetime	timestamp
datetime2	timestamp
decimal	decimal
float	decimal
int	integer
money	decimal
nchar	string
ntext	string
numeric	decimal
nvarchar	string
smallmoney	decimal
text	string
varchar	string

PostgreSQL data types

The following table lists the data types that you can use with a PostgreSQL Server data source when using the Managed Access setting in a delivery template in Data Marketplace:

PostgreSQL data type	Data Access Management data type
int2 (smallint)	integer
int4 (integer)	integer
int8 (bigint)	integer
numeric (decimal)	decimal
float4 (real)	decimal
float8 (double)	decimal
varchar	string
text	string
date	date
timestamp	timestamp
timestampz	timestamp
smallserial	integer
money	decimal

Oracle data types

The following table lists the data types that you can use with an Oracle data source when using the Managed Access setting in a delivery template in Data Marketplace and with access policy transformations in Data Integration:

Oracle data type	Data Access Management data type
CHAR	string
DATE	timestamp
DECIMAL	decimal
DOUBLE PRECISION	decimal
FLOAT	decimal
INTEGER	decimal
LONG	string
NCHAR	string
NUMBER	decimal
NVARCHAR2	string
REAL	decimal
SMALLINT	decimal
TIMESTAMP	timestamp
TIMESTAMP WITH LOCAL TIME ZONE	timestamp
VARCHAR	string
VARCHAR2	string

Available data protections

Data Access Management data type	Description	Available data protections
date	A calendar date	generalize date, redact to null, retain
decimal	A numeric value	redact to null, retain
integer	A positive natural number or zero	regular expression number generator, redact to null, retain
string	A sequence of characters	constant text value, truncate text, regular expression, redact to null, retain
timestamp	The date and time that an event occurred	generalize date, redact to null, retain
unknown	No corresponding data type in Data Access Management	redact to null, retain