Hi -- this is my code, believe none of the fields are numeric:
CREATE EXTERNAL DATA SOURCE external_pg5
WITH ( LOCATION = 'odbc://192.168.0.169',
CONNECTION_OPTIONS = 'Driver={DenodoODBC Unicode(x64)};
DSN = PG5',
PUSHDOWN = ON,
CREDENTIAL = credential_deno );
GO
CREATE EXTERNAL TABLE payment5(
payment_id INT NOT NULL,
customer_id SMALLINT NOT NULL,
staff_id SMALLINT NOT NULL,
rental_id INT NOT NULL,
amount DECIMAL(5, 2) NOT NULL,
payment_date DATETIME2(6) NOT NULL
)
WITH (
LOCATION='payment',
DATA_SOURCE=external_pg5
);
GO
SELECT * FROM dbo.payment5
GO