+1 interesting fact - MS has a similar syntax COPY INTO (Transact-SQL) - Azure Synapse Analytics and Microsoft Fabric | Microsoft Learn <https://learn.microsoft.com/en-us/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest>
Best, Taewoo On Fri, Oct 27, 2023 at 11:11 AM Glenn Justo Galvizo <[email protected]> wrote: > +1 from me as well! > > > On Oct 27, 2023, at 10:15, Till Westmann <[email protected]> wrote: > > > > +1 this is much nicer > > > >> On 2023/10/26 05:05:01 Mike Carey wrote: > >> PS - I assume the semantics will be UPSERT-based? (Vs. one-time or > >> INSERT-based?) > >> > >>> On 10/24/23 10:16 AM, Wail Alkowaileet wrote: > >>> Hi all, > >>> > >>> I'm proposing to change the current syntax for COPY FROM. The current > >>> syntax looks as follows: > >>> > >>>> COPY Customers > >>>> USING localfs ( > >>>> ("path"="asterix_nc1://data/nontagged/customerData.json"), > >>>> ("format"="json") > >>>> ); > >>>> > >>> This syntax uses the old way of configuring the adapter localfs. In our > >>> feeds, we use the WITH clause. Another issue is that the current > syntax is > >>> missing the keyword FROM, which makes it ambiguous if we add support > for > >>> COPY TO. > >>> > >>> I propose to change the syntax to be as follows: > >>> > >>>> COPY Customers > >>>> FROM localfs > >>>> PATH ("asterix_nc1://data/nontagged/customerData.json") > >>>> WITH { > >>>> "format": "json" > >>>> }; > >>>> > >>> First, the proposed syntax introduces the use of FROM <adapterName>. > >>> Second, it mandates the use of PATH (instead of having it in the WITH > >>> clause). Additionally, the proposed syntax will make both COPY FROM and > >>> COPY TO less different. > >>> > >>> Example of COPY TO: > >>> > >>>> COPY Customers > >>>> TO localfs > >>>> PATH("localhost:///myData/Customers") > >>>> WITH { > >>>> "format" : "json" > >>>> }; > >>>> >
