DataFrame.createOrReplaceTempView(name: Union[str, Iterable[str]], *, comment: Optional[str] = None, statement_params: Optional[Dict[str, str]] = None) List[Row][source]

Creates a temporary view that returns the same results as this DataFrame.

You can use the view in subsequent SQL queries and statements during the current session. The temporary view is only available in the session in which it is created.

For name, you can include the database and schema name (i.e. specify a fully-qualified name). If no database name or schema name are specified, the view will be created in the current database or schema.

name must be a valid Snowflake identifier.

  • name – The name of the view to create or replace. Can be a list of strings that specifies the database name, schema name, and view name.

  • comment – Adds a comment for the created view. See COMMENT.

  • statement_params – Dictionary of statement level parameters to be set while executing this action.