jashwood

CREATE EXTERNAL TABLE with filepath() or filename() calculated column gives syntax error

1

CREATE EXTERNAL TABLE [stg].[my_table] ( [COLUMN_ONE] VARCHAR (50) NULL, [filepath] AS CAST(filepath() AS NVARCHAR(1024)), [filename] AS CAST(filename() AS NVARCHAR(1024)) ) WITH ( DATA_SOURCE = [DataSource1], LOCATION = N'somepath/somefile*.csv', FILE_FORMAT =...