ibis.omniscidb.api.OmniSciDBClient.create_table

OmniSciDBClient.create_table(table_name: str, obj: Optional[Union[ibis.expr.types.TableExpr, pandas.core.frame.DataFrame]] = None, schema: Optional[ibis.expr.schema.Schema] = None, database: Optional[str] = None, max_rows: Optional[int] = None, fragment_size: Optional[int] = None, is_temporary: bool = False, **kwargs)

Create a new table from an Ibis table expression.

Parameters
  • table_name (str) –

  • obj (TableExpr or pandas.DataFrame, optional, default None) – If passed, creates table from select statement results

  • schema (ibis.Schema, optional, default None) –

  • table_name

  • obj – If passed, creates table from select statement results.

  • schema – Mutually exclusive with expr, creates an empty table with a particular schema

  • database (str, optional, default None) –

  • max_rows (int, optional, default None) – Set the maximum number of rows allowed in a table to create a capped collection. When this limit is reached, the oldest fragment is removed.

  • fragment_size (int, optional,) – default 32000000 if gpu_device is enabled otherwise 5000000 Number of rows per fragment that is a unit of the table for query processing, which is not expected to be changed.

  • is_temporary (bool, default False) – If True it the table will be created as temporary.

Examples

>>> con.create_table('new_table_name', table_expr)