AT LOCATION

Description

Creates a remote table (proxy). (Sybase SQL Language Reference)

This syntax is not supported in Snowflake.

Grammar Syntax

AT <location-string>

Sample Source Patterns

Input Code:

Sybase

IN -> Sybase_01.sql

CREATE TABLE t1
( 
    DATA VARCHAR(10)
)
AT 'SERVER_A.db1.joe.t1'; 

Output Code:

Snowflake

OUT -> Sybase_01.sql

CREATE OR REPLACE TABLE t1
(
    DATA VARCHAR(10)
)
    !!!RESOLVE EWI!!! /*** SSC-EWI-SY0002 - UNSUPPORTED REMOTE TABLE SYNTAX ***/!!!
AT 'SERVER_A.db1.joe.t1'
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "sybase",  "convertedOn": "07/11/2025",  "domain": "no-domain-provided" }}'
;

Related EWIs

SSC-EWI-SY0002: UNSUPPORTED REMOTE TABLE SYNTAX.