convert_table_to_sql_id

Converts a tibble of table metadata (<code>table_catalog</code>, <code>table_schema</code>,
<code>table_name</code>) into a list of <code><a href="https://dbi.r-dbi.org/reference/Id.html">DBI::Id</a></code> SQL identifiers.
Useful for safely quoting fully qualified table references in
<code>DBI</code>/<code>dbplyr</code> workflows.

internal

Provides helper functions, metadata utilities, and workflows for
administering and managing databases on the 'Motherduck' cloud platform.
Some features require a 'Motherduck' account (<https://motherduck.com/>).

Alejandro Hagan

motherduck

Utilities for Managing a 'Motherduck' Database

convert_table_to_sql_id function

<dl><dt>x</dt>
<dd>A tibble or data frame containing the columns:<ul>
<li><code>table_catalog</code> — database/catalog name</li>
<li><code>table_schema</code> — schema name</li>
<li><code>table_name</code> — table name</li>
</ul></dd></dl>

Arguments

Converts a tibble of table metadata (<code>table_catalog</code>, <code>table_schema</code>,
<code>table_name</code>) into a list of <code><a href='https://dbi.r-dbi.org/reference/Id.html'>DBI::Id</a></code> SQL identifiers.
Useful for safely quoting fully qualified table references in
<code>DBI</code>/<code>dbplyr</code> workflows.

Convert Table Metadata to SQL Identifiers — convert_table_to_sql_id

<dl>

<dt>x</dt>
<dd>A tibble or data frame containing the columns:<ul>
<li><code>table_catalog</code> — database/catalog name</li>
<li><code>table_schema</code> — schema name</li>
<li><code>table_name</code> — table name</li>
</ul></dd>

</dl>

convert_table_to_sql_id: Convert Table Metadata to SQL Identifiers

Description

Usage

Value

Arguments