odbcConnectionColumns_,Snowflake,character-method

dbExistsTableForWrite,Snowflake,character-method

<div class="section" id="odbcconnectioncolumns-">
<h3><code>odbcConnectionColumns()</code></h3>
If the catalog, or the schema arguments are NULL, attempt to infer
by querying for CURRENT_DATABASE() and CURRENT_SCHEMA(). We do this
to aid with performance, as the SQLColumns method is more performant
when restricted to a particular DB/schema.
</div>

A DBI-compatible interface to ODBC databases.

Hadley Wickham

odbc

Connect to ODBC Compatible Databases (using the DBI Interface)

Jim Hester

Oliver Gjoneski

Simon Couch

lexicalunit 

Google Inc. 

Posit Software, PBC 

odbcConnectionColumns_,Snowflake,character-method function

<dl><dt>conn</dt>
<dd>A <a href="https://dbi.r-dbi.org/reference/DBIConnection-class.html">DBI::DBIConnection</a> object, as returned by
<code>dbConnect()</code>.</dd>
<dt>name</dt>
<dd>The table name, passed on to <code><a href="https://dbi.r-dbi.org/reference/dbQuoteIdentifier.html">dbQuoteIdentifier()</a></code>. Options are:<ul>
<li>a character string with the unquoted DBMS table name,
e.g. <code>"table_name"</code>,</li>
<li>a call to <code><a href="https://dbi.r-dbi.org/reference/Id.html">Id()</a></code> with components to the fully qualified table name,
e.g. <code>Id(schema = "my_schema", table = "table_name")</code></li>
<li>a call to <code><a href="https://dbi.r-dbi.org/reference/SQL.html">SQL()</a></code> with the quoted and fully qualified table name
given verbatim, e.g. <code>SQL('"my_schema"."table_name"')</code></li>
</ul></dd>
<dt>...</dt>
<dd>Other parameters passed on to methods.</dd>
<dt>catalog_name, schema_name</dt>
<dd>Catalog and schema names.</dd></dl>

Arguments

<div class='section' id='odbcconnectioncolumns-'>
<h3><code>odbcConnectionColumns()</code></h3>


If the catalog, or the schema arguments are NULL, attempt to infer
by querying for CURRENT_DATABASE() and CURRENT_SCHEMA(). We do this
to aid with performance, as the SQLColumns method is more performant
when restricted to a particular DB/schema.
</div>

Connecting to Snowflake via ODBC — odbcConnectionColumns_,Snowflake,character-method

<dl>

<dt>conn</dt>
<dd>A <a href='https://dbi.r-dbi.org/reference/DBIConnection-class.html'>DBI::DBIConnection</a> object, as returned by
<code>dbConnect()</code>.</dd>


<dt>name</dt>
<dd>The table name, passed on to <code><a href='https://dbi.r-dbi.org/reference/dbQuoteIdentifier.html'>dbQuoteIdentifier()</a></code>. Options are:<ul>
<li>a character string with the unquoted DBMS table name,
e.g. <code>"table_name"</code>,</li>
<li>a call to <code><a href='https://dbi.r-dbi.org/reference/Id.html'>Id()</a></code> with components to the fully qualified table name,
e.g. <code>Id(schema = "my_schema", table = "table_name")</code></li>
<li>a call to <code><a href='https://dbi.r-dbi.org/reference/SQL.html'>SQL()</a></code> with the quoted and fully qualified table name
given verbatim, e.g. <code>SQL('"my_schema"."table_name"')</code></li>
</ul></dd>


<dt>...</dt>
<dd>Other parameters passed on to methods.</dd>


<dt>catalog_name, schema_name</dt>
<dd>Catalog and schema names.</dd>

</dl>

odbcConnectionColumns_,Snowflake,character-method: Connecting to Snowflake via ODBC

Description

`odbcConnectionColumns()`

Usage

Arguments