Data Type correspondence

The types for the columns in the staging table are based on the DbType of the .Net library System.Data (https://learn.microsoft.com/fr-fr/dotnet/api/system.data.dbtype?view=net-8.0 ). They are translated into database type depending on the target database type that you have.

Here is the matching table for each type. Note that the types marked as cannot be used in a staging table for the target database and will result in an error during the creation of the staging table.

beVault	PostgreSQL	SQL Server	Snowflake
AnsiString	varchar	varchar	VARCHAR
Binary	bytea	varbinary	BINARY
Byte		binary	BINARY
Boolean	bool	bit	BOOLEAN
Currency	numeric	decimal	NUMBER
Date	date	date	DATE
DateTime	timestamp	datetime2	TIMESTAMP_NTZ
Decimal	numeric	decimal	NUMBER
Double	float8	float(8)	FLOAT
Guid	uuid	uniqueidentifier	BINARY
Int16	int2	smallint	NUMBER
Int32	int4	int	NUMBER
Int64	int8	bigint	NUMBER
Object			OBJECT
SByte			BINARY
Single	float4	float(8)	FLOAT
String	varchar	varchar	VARCHAR
Time	time	time	TIME
UInt16	int2	smallint	NUMBER
UInt32	int4	int	NUMBER
UInt64	int8	bigint	NUMBER
VarNumeric	numeric	decimal	NUMBER
AnsiStringFixedLength	bpchar	char	VARCHAR
StringFixedLength	bpchar	char	VARCHAR
Xml	xml	xml	VARCHAR
DateTime2	timestamp	datetime2	TIMESTAMP_NTZ
DateTimeOffset			TIMESTAMP_TZ