mteb/BrightProStackoverflowRetrieval huggingface dataset:
eedback/report?space=61) This page

[ View all page feedback  ](https://github.com/dotnet/dotnet-api-docs/issues)

[ California Consumer Privacy Act (CCPA) Opt-Out Icon  Your Privacy Choices
](https://aka.ms/yourcaliforniaprivacychoices)

Theme

  * Light 
  * Dark 
  * High contrast 

  *   * [ Previous Versions ](/en-us/previous-versions/)
  * [ Blog ](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog)
  * [ Contribute ](/en-us/contribute/)
  * [ Privacy ](https://go.microsoft.com/fwlink/?LinkId=521839)
  * [ Terms of Use ](/en-us/legal/termsofuse)
  * [ Trademarks ](https://www.microsoft.com/legal/intellectualproperty/Trademarks/)
  * © Microsoft 2024 

##  Additional resources

###  In this article

[ California Consumer Privacy Act (CCPA) Opt-Out Icon  Your Privacy Choices
](https://aka.ms/yourcaliforniaprivacychoices)

Theme

  * Light 
  * Dark 
  * High contrast 

  *   * [ Previous Versions ](/en-us/previous-versions/)
  * [ Blog ](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog)
  * [ Contribute ](/en-us/contribute/)
  * [ Privacy ](https://go.microsoft.com/fwlink/?LinkId=521839)
  * [ Terms of Use ](/en-us/legal/termsofuse)
  * [ Trademarks ](https://www.microsoft.com/legal/intellectualproperty/Trademarks/)
  * © Microsoft 2024
* [ Code  ](/npgsql/npgsql)
* [ Issues  ](/npgsql/npgsql/issues)
* [ Pull requests  ](/npgsql/npgsql/pulls)
* [ Actions  ](/npgsql/npgsql/actions)
* [ Security  ](/npgsql/npgsql/security)
* [ Insights  ](/npgsql/npgsql/pulse)
[ pandas.io.formats.style.Styler.set_uuid ](pandas.io.formats.style.Styler.set_uuid.html)
    * [ pandas.io.formats.style.Styler.clear ](pandas.io.formats.style.Styler.clear.html)
    * [ pandas.io.formats.style.Styler.pipe ](pandas.io.formats.style.Styler.pipe.html)
    * [ pandas.io.formats.style.Styler.highlight_null ](pandas.io.formats.style.Styler.highlight_null.html)
    * [ pandas.io.formats.style.Styler.highlight_max ](pandas.io.formats.style.Styler.highlight_max.html)
    * [ pandas.io.formats.style.Styler.highlight_min ](pandas.io.formats.style.Styler.highlight_min.html)
    * [ pandas.io.formats.style.Styler.highlight_between ](pandas.io.formats.style.Styler.highlight_between.html)
    * [ pandas.io.formats.style.Styler.highlight_quantile ](pandas.io.formats.style.Styler.highlight_quantile.html)
    * [ pandas.io.formats.style.Styler.background_gradient ](pandas.io.formats.style.Styler.background_gradient.html)
    * [ pandas.io.formats.style.Styler.text_gradient ](pandas.io.formats.style.Styler.text_gradient.html)
    * [ pandas.io.formats.style.Styler.bar ](pandas.io.formats.style.Styler.bar.html)
    * [ pandas.io.formats.style.Styler.to_html ](pandas.io.formats.style.Styler.to_html.html)
    * [ pandas.io.formats.style.Styler.to_latex ](pandas.io.formats.style.Styler.to_latex.html)
    * [ pandas.io.formats.style.Styler.to_excel ](pandas.io.formats.style.Styler.to_excel.html)
    * [ pandas.io.formats.style.Styler.to_string ](pandas.io.formats.style.Styler.to_string.html)
    * [ pandas.io.formats.style.Styler.export ](pandas.io.formats.style.Styler.export.html)
    * [ pandas.io.formats.style.Styler.use ](pandas.io.formats.style.Styler.use.html)
  * [ Plotting ](../plotting.html)
  * [ Options and settings ](../options.html)
  * [ Extensions ](../extensions.html)
  * [ Testing ](../testing.html)
  * [ Missing values ](../missing_value.html)

  * [ __ ](../../index.html)
  * [ API reference ](../index.html)
  * [ Style ](../style.html)
  * pandas.io.fo... 

#  pandas.io.formats.style.Styler.loader  #

Styler.  loader  _ =  <jinja2.loaders.PackageLoader  object> _ #

    

[ __ previous  pandas.io.formats.style.Styler.template_string
](pandas.io.formats.style.Styler.template_string.html "previous page") [ next
pandas.io.formats.style.Styler.apply  __
](pandas.io.formats.style.Styler.apply.html "next page")

__ On this page

  * ` Styler.loader  `

[ __ Show Source
](../../_sources/reference/api/pandas.io.formats.style.Styler.loader.rst.txt)

© 2024, pandas via [ NumFOCUS, Inc. ](https://numfocus.org) Hosted by [
OVHcloud ](https://www.ovhcloud.com) .

Created using [ Sphinx ](https://www.sphinx-doc.org/) 7.2.6.  

Built with the [ PyData Sphinx Theme ](https://pydata-sphinx-
theme.readthedocs.io/en/stable/index.html) 0.14.4.
io.formats.style.Styler.set_uuid ](pandas.io.formats.style.Styler.set_uuid.html)
    * [ pandas.io.formats.style.Styler.clear ](pandas.io.formats.style.Styler.clear.html)
    * [ pandas.io.formats.style.Styler.pipe ](pandas.io.formats.style.Styler.pipe.html)
    * [ pandas.io.formats.style.Styler.highlight_null ](pandas.io.formats.style.Styler.highlight_null.html)
    * [ pandas.io.formats.style.Styler.highlight_max ](pandas.io.formats.style.Styler.highlight_max.html)
    * [ pandas.io.formats.style.Styler.highlight_min ](pandas.io.formats.style.Styler.highlight_min.html)
    * [ pandas.io.formats.style.Styler.highlight_between ](pandas.io.formats.style.Styler.highlight_between.html)
    * [ pandas.io.formats.style.Styler.highlight_quantile ](pandas.io.formats.style.Styler.highlight_quantile.html)
    * [ pandas.io.formats.style.Styler.background_gradient ](pandas.io.formats.style.Styler.background_gradient.html)
    * [ pandas.io.formats.style.Styler.text_gradient ](pandas.io.formats.style.Styler.text_gradient.html)
    * [ pandas.io.formats.style.Styler.bar ](pandas.io.formats.style.Styler.bar.html)
    * [ pandas.io.formats.style.Styler.to_html ](pandas.io.formats.style.Styler.to_html.html)
    * [ pandas.io.formats.style.Styler.to_latex ](pandas.io.formats.style.Styler.to_latex.html)
    * [ pandas.io.formats.style.Styler.to_excel ](pandas.io.formats.style.Styler.to_excel.html)
    * [ pandas.io.formats.style.Styler.to_string ](pandas.io.formats.style.Styler.to_string.html)
    * [ pandas.io.formats.style.Styler.export ](pandas.io.formats.style.Styler.export.html)
    * [ pandas.io.formats.style.Styler.use ](pandas.io.formats.style.Styler.use.html)
  * [ Plotting ](../plotting.html)
  * [ Options and settings ](../options.html)
  * [ Extensions ](../extensions.html)
  * [ Testing ](../testing.html)
  * [ Missing values ](../missing_value.html)

  * [ __ ](../../index.html)
  * [ API reference ](../index.html)
  * [ Style ](../style.html)
  * pandas.io.fo... 

#  pandas.io.formats.style.Styler.template_string  #

Styler.  template_string  _ =  <Template  'string.tpl'> _ #

    

[ __ previous  pandas.io.formats.style.Styler.template_latex
](pandas.io.formats.style.Styler.template_latex.html "previous page") [ next
pandas.io.formats.style.Styler.loader  __
](pandas.io.formats.style.Styler.loader.html "next page")

__ On this page

  * ` Styler.template_string  `

[ __ Show Source
](../../_sources/reference/api/pandas.io.formats.style.Styler.template_string.rst.txt)

© 2024, pandas via [ NumFOCUS, Inc. ](https://numfocus.org) Hosted by [
OVHcloud ](https://www.ovhcloud.com) .

Created using [ Sphinx ](https://www.sphinx-doc.org/) 7.2.6.  

Built with the [ PyData Sphinx Theme ](https://pydata-sphinx-
theme.readthedocs.io/en/stable/index.html) 0.14.4.
* [ pandas.io.formats.style.Styler.set_uuid ](pandas.io.formats.style.Styler.set_uuid.html)
    * [ pandas.io.formats.style.Styler.clear ](pandas.io.formats.style.Styler.clear.html)
    * [ pandas.io.formats.style.Styler.pipe ](pandas.io.formats.style.Styler.pipe.html)
    * [ pandas.io.formats.style.Styler.highlight_null ](pandas.io.formats.style.Styler.highlight_null.html)
    * [ pandas.io.formats.style.Styler.highlight_max ](pandas.io.formats.style.Styler.highlight_max.html)
    * [ pandas.io.formats.style.Styler.highlight_min ](pandas.io.formats.style.Styler.highlight_min.html)
    * [ pandas.io.formats.style.Styler.highlight_between ](pandas.io.formats.style.Styler.highlight_between.html)
    * [ pandas.io.formats.style.Styler.highlight_quantile ](pandas.io.formats.style.Styler.highlight_quantile.html)
    * [ pandas.io.formats.style.Styler.background_gradient ](pandas.io.formats.style.Styler.background_gradient.html)
    * [ pandas.io.formats.style.Styler.text_gradient ](pandas.io.formats.style.Styler.text_gradient.html)
    * [ pandas.io.formats.style.Styler.bar ](pandas.io.formats.style.Styler.bar.html)
    * [ pandas.io.formats.style.Styler.to_html ](pandas.io.formats.style.Styler.to_html.html)
    * [ pandas.io.formats.style.Styler.to_latex ](pandas.io.formats.style.Styler.to_latex.html)
    * [ pandas.io.formats.style.Styler.to_excel ](pandas.io.formats.style.Styler.to_excel.html)
    * [ pandas.io.formats.style.Styler.to_string ](pandas.io.formats.style.Styler.to_string.html)
    * [ pandas.io.formats.style.Styler.export ](pandas.io.formats.style.Styler.export.html)
    * [ pandas.io.formats.style.Styler.use ](pandas.io.formats.style.Styler.use.html)
  * [ Plotting ](../plotting.html)
  * [ Options and settings ](../options.html)
  * [ Extensions ](../extensions.html)
  * [ Testing ](../testing.html)
  * [ Missing values ](../missing_value.html)

  * [ __ ](../../index.html)
  * [ API reference ](../index.html)
  * [ Style ](../style.html)
  * pandas.io.fo... 

#  pandas.io.formats.style.Styler.env  #

Styler.  env  _ =  <jinja2.environment.Environment  object> _ #

    

[ __ previous  pandas.io.formats.style.Styler.from_custom_template
](pandas.io.formats.style.Styler.from_custom_template.html "previous page") [
next  pandas.io.formats.style.Styler.template_html  __
](pandas.io.formats.style.Styler.template_html.html "next page")

__ On this page

  * ` Styler.env  `

[ __ Show Source
](../../_sources/reference/api/pandas.io.formats.style.Styler.env.rst.txt)

© 2024, pandas via [ NumFOCUS, Inc. ](https://numfocus.org) Hosted by [
OVHcloud ](https://www.ovhcloud.com) .

Created using [ Sphinx ](https://www.sphinx-doc.org/) 7.2.6.  

Built with the [ PyData Sphinx Theme ](https://pydata-sphinx-
theme.readthedocs.io/en/stable/index.html) 0.14.4.
.io.formats.style.Styler.set_uuid ](pandas.io.formats.style.Styler.set_uuid.html)
    * [ pandas.io.formats.style.Styler.clear ](pandas.io.formats.style.Styler.clear.html)
    * [ pandas.io.formats.style.Styler.pipe ](pandas.io.formats.style.Styler.pipe.html)
    * [ pandas.io.formats.style.Styler.highlight_null ](pandas.io.formats.style.Styler.highlight_null.html)
    * [ pandas.io.formats.style.Styler.highlight_max ](pandas.io.formats.style.Styler.highlight_max.html)
    * [ pandas.io.formats.style.Styler.highlight_min ](pandas.io.formats.style.Styler.highlight_min.html)
    * [ pandas.io.formats.style.Styler.highlight_between ](pandas.io.formats.style.Styler.highlight_between.html)
    * [ pandas.io.formats.style.Styler.highlight_quantile ](pandas.io.formats.style.Styler.highlight_quantile.html)
    * [ pandas.io.formats.style.Styler.background_gradient ](pandas.io.formats.style.Styler.background_gradient.html)
    * [ pandas.io.formats.style.Styler.text_gradient ](pandas.io.formats.style.Styler.text_gradient.html)
    * [ pandas.io.formats.style.Styler.bar ](pandas.io.formats.style.Styler.bar.html)
    * [ pandas.io.formats.style.Styler.to_html ](pandas.io.formats.style.Styler.to_html.html)
    * [ pandas.io.formats.style.Styler.to_latex ](pandas.io.formats.style.Styler.to_latex.html)
    * [ pandas.io.formats.style.Styler.to_excel ](pandas.io.formats.style.Styler.to_excel.html)
    * [ pandas.io.formats.style.Styler.to_string ](pandas.io.formats.style.Styler.to_string.html)
    * [ pandas.io.formats.style.Styler.export ](pandas.io.formats.style.Styler.export.html)
    * [ pandas.io.formats.style.Styler.use ](pandas.io.formats.style.Styler.use.html)
  * [ Plotting ](../plotting.html)
  * [ Options and settings ](../options.html)
  * [ Extensions ](../extensions.html)
  * [ Testing ](../testing.html)
  * [ Missing values ](../missing_value.html)

  * [ __ ](../../index.html)
  * [ API reference ](../index.html)
  * [ Style ](../style.html)
  * pandas.io.fo... 

#  pandas.io.formats.style.Styler.template_latex  #

Styler.  template_latex  _ =  <Template  'latex.tpl'> _ #

    

[ __ previous  pandas.io.formats.style.Styler.template_html_table
](pandas.io.formats.style.Styler.template_html_table.html "previous page") [
next  pandas.io.formats.style.Styler.template_string  __
](pandas.io.formats.style.Styler.template_string.html "next page")

__ On this page

  * ` Styler.template_latex  `

[ __ Show Source
](../../_sources/reference/api/pandas.io.formats.style.Styler.template_latex.rst.txt)

© 2024, pandas via [ NumFOCUS, Inc. ](https://numfocus.org) Hosted by [
OVHcloud ](https://www.ovhcloud.com) .

Created using [ Sphinx ](https://www.sphinx-doc.org/) 7.2.6.  

Built with the [ PyData Sphinx Theme ](https://pydata-sphinx-
theme.readthedocs.io/en/stable/index.html) 0.14.4.
Syntax  ¶
    ALTER EXTERNAL VOLUME [ IF EXISTS ] <name> ADD STORAGE_LOCATION =
                                                 (
                                                 NAME = '<name>'
                                                 cloudProviderParams
                                                 )
    ALTER EXTERNAL VOLUME [ IF EXISTS ] <name> REMOVE STORAGE_LOCATION '<name>'
    ALTER EXTERNAL VOLUME [ IF EXISTS ] <name> SET ALLOW_WRITES = TRUE
    ALTER EXTERNAL VOLUME [ IF EXISTS ] <name> SET COMMENT = '<string_literal>'
Copy
Where:
>
>     cloudProviderParams (for Amazon S3) ::=
>       STORAGE_PROVIDER = 'S3'
>       STORAGE_AWS_ROLE_ARN = '<iam_role>'
>       STORAGE_BASE_URL = 's3://<bucket>[/<path>/]'
>       [ ENCRYPTION = ( [ TYPE = 'AWS_SSE_S3' ] |
>                   [ TYPE = 'AWS_SSE_KMS' [ KMS_KEY_ID = '<string>' ] ] |
>                   [ TYPE = 'NONE' ] ) ]
>  
>
> Copy
>  
>  
>     cloudProviderParams (for Google Cloud Storage) ::=
>       STORAGE_PROVIDER = 'GCS'
>       STORAGE_BASE_URL = 'gcs://<bucket>[/<path>/]'
>       [ ENCRYPTION = ( [ TYPE = 'GCS_SSE_KMS' ] [ KMS_KEY_ID = '<string>' ]
> |
>                   [ TYPE = 'NONE' ] ) ]
>  
>
> Copy
>  
>  
>     cloudProviderParams (for Microsoft Azure) ::=
>       STORAGE_PROVIDER = 'AZURE'
>       AZURE_TENANT_ID = '<tenant_id>'
>       STORAGE_BASE_URL =
> 'azure://<account>.blob.core.windows.net/<container>[/<path>/]'
>  
>
> Copy
Syntax  ¶
    CREATE [ OR REPLACE ] MODEL [ IF NOT EXISTS ] <name> FROM internalStage;
Copy
Where:
    internalStage ::=
        @[<namespace>.]<int_stage_name>[/<path>]
      | @[<namespace>.]%<table_name>[/<path>]
      | @~[/<path>]
Copy
For additional internal stage details, see [ Choosing an internal stage for
Syntax  ¶
    ALTER MODEL [ IF EXISTS ] <name> ADD VERSION <version_name> FROM internalStage
Copy
Where:
    internalStage ::=
        @[<namespace>.]<int_stage_name>[/<path>]
    | @[<namespace>.]%<table_name>[/<path>]
    | @~[/<path>]
Copy
For additional internal stage details, see [ Choosing an internal stage for
Syntax  ¶
    COPY INTO { internalStage | externalStage | externalLocation }
         FROM { [<namespace>.]<table_name> | ( <query> ) }
    [ PARTITION BY <expr> ]
    [ FILE_FORMAT = ( { FORMAT_NAME = '[<namespace>.]<file_format_name>' |
                        TYPE = { CSV | JSON | PARQUET } [ formatTypeOptions ] } ) ]
    [ copyOptions ]
    [ VALIDATION_MODE = RETURN_ROWS ]
    [ HEADER ]
Copy
Where:
>
>     internalStage ::=
>         @[<namespace>.]<int_stage_name>[/<path>]
>       | @[<namespace>.]%<table_name>[/<path>]
>       | @~[/<path>]
>  
>
> Copy
>  
>  
>     externalStage ::=
>       @[<namespace>.]<ext_stage_name>[/<path>]
>  
>
> Copy
>  
>  
>     externalLocation (for Amazon S3) ::=
>       's3://<bucket>[/<path>]'
>       [ { STORAGE_INTEGRATION = <integration_name> } | { CREDENTIALS = ( {
> { AWS_KEY_ID = '<string>' AWS_SECRET_KEY = '<string>' [ AWS_TOKEN =
> '<string>' ] } } ) } ]
>       [ ENCRYPTION = ( [ TYPE = 'AWS_CSE' ] [ MASTER_KEY = '<string>' ] |
>                        [ TYPE = 'AWS_SSE_S3' ] |
>                        [ TYPE = 'AWS_SSE_KMS' [ KMS_KEY_ID = '<string>' ] ]
> |
>                        [ TYPE = 'NONE' ] ) ]
>  
>
> Copy
>  
>  
>     externalLocation (for Google Cloud Storage) ::=
>       'gcs://<bucket>[/<path>]'
>       [ STORAGE_INTEGRATION = <integration_name> ]
>       [ ENCRYPTION = ( [ TYPE = 'GCS_SSE_KMS' ] [ KMS_KEY_ID = '<string>' ]
> | [ TYPE = 'NONE' ] ) ]
>  
>
> Copy
>  
>  
>     externalLocation (for Microsoft Azure) ::=
>       'azure://<account>.blob.core.windows.net/<container>[/<path>]'
>       [ { STORAGE_INTEGRATION = <integration_name> } | { CREDENTIALS = ( [
> AZURE_SAS_TOKEN = '<string>' ] ) } ]
>       [ ENCRYPTION = ( [ TYPE = { 'AZURE_CSE' | 'NONE' } ] [ MASTER_KEY =
> '<string>' ] ) ]
>  
>
> Copy
>  
>  
>     formatTypeOptions ::=
>     -- If FILE_FORMAT = ( TYPE = CSV ... )
>          COMPRESSION = AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE |
> RAW_DEFLATE | NONE
>          RECORD_DELIMITER = '<character>' | NONE
>          FIELD_DELIMITER = '<character>' | NONE
>          FILE_EXTENSION = '<string>'
>          ESCAPE = '<character>' | NONE
>          ESCAPE_UNENCLOSED_FIELD = '<character>' | NONE
>          DATE_FORMAT = '<string>' | AUTO
>          TIME_FORMAT = '<string>' | AUTO
>          TIMESTAMP_FORMAT = '<string>' | AUTO
>          BINARY_FORMAT = HEX | BASE64 | UTF8
>          FIELD_OPTIONALLY_ENCLOSED_BY = '<character>' | NONE
>          NULL_IF = ( '<string1>' [ , '<string2>' , ... ] )
>          EMPTY_FIELD_AS_NULL = TRUE | FALSE
>     -- If FILE_FORMAT = ( TYPE = JSON ... )
>          COMPRESSION = AUTO | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE |
> RAW_DEFLATE | NONE
>          FILE_EXTENSION = '<string>'
>     -- If FILE_FORMAT = ( TYPE = PARQUET ... )
>          COMPRESSION = AUTO | LZO | SNAPPY | NONE
>          SNAPPY_COMPRESSION = TRUE | FALSE
>  
>
> Copy
>  
>  
>     copyOptions ::=
>          OVERWRITE = TRUE | FALSE
>          SINGLE = TRUE | FALSE
>          MAX_FILE_SIZE = <num>
>          INCLUDE_QUERY_ID = TRUE | FALSE
>          DETAILED_OUTPUT = TRUE | FALSE
>  
>
> Copy
Syntax  ¶
    PUT file://<path_to_file>/<filename> internalStage
        [ PARALLEL = <integer> ]
        [ AUTO_COMPRESS = TRUE | FALSE ]
        [ SOURCE_COMPRESSION = AUTO_DETECT | GZIP | BZ2 | BROTLI | ZSTD | DEFLATE | RAW_DEFLATE | NONE ]
        [ OVERWRITE = TRUE | FALSE ]
Copy
Where:
>
>     internalStage ::=
>         @[<namespace>.]<int_stage_name>[/<path>]
>       | @[<namespace>.]%<table_name>[/<path>]
>       | @~[/<path>]
>  
>
> Copy
Syntax  ¶
    INFER_SCHEMA(
      LOCATION => '{ internalStage | externalStage }'
      , FILE_FORMAT => '<file_format_name>'
      , FILES => '<file_name>' [ , '<file_name>' ] [ , ... ]
      , IGNORE_CASE => TRUE | FALSE
      , MAX_FILE_COUNT => <num>
      , MAX_RECORDS_PER_FILE => <num>
    )
Copy
Where:
>
>     internalStage ::=
>         @[<namespace>.]<int_stage_name>[/<path>][/<filename>]
>       | @~[/<path>][/<filename>]
>  
>
> Copy
>  
>  
>     externalStage ::=
>       @[<namespace>.]<ext_stage_name>[/<path>][/<filename>]
>  
>
> Copy
Partitions added and removed manually  ¶
Use the following parameters to add or remove partitions when the partition
type for the external table is user-specified (i.e. ` PARTITION_TYPE  =
USER_SPECIFIED  ` ):
` ADD  PARTITION  (  <part_col_name> =  '<string>'  [  ,  <part_col_name> =
'<string>'  ,  ...  ]  )  LOCATION  '<path>'  `
Manually add a partition for one or more partition columns defined for the
external table in a specified location (i.e. path).
Note
The maximum length of user-specified partition column names is 32 characters.
Adding a partition also adds any new or updated files in the location to the
external table metadata.
` DROP  PARTITION  LOCATION  '<path>'  `
Manually drop all partitions in a specified location (i.e. path).
Dropping a partition also removes any files in the location from the external
table metadata.
AFTER MATCH SKIP: Specifying Where to Continue After a Match  ¶
    AFTER MATCH SKIP
    {
        PAST LAST ROW   |
        TO NEXT ROW   |
        TO [ { FIRST | LAST} ] <symbol>
    }
Copy
This subclause specifies where to continue the matching after a positive match
was found.
  * ` PAST  LAST  ROW  (default)  `
Continue matching after the last row of the current match.
This prevents matches that contain overlapping rows. For example, if you have
a stock pattern that contains 3 ` V  ` shapes in a row, then ` PAST  LAST  ROW
` finds one ` W  ` pattern, not two.
  * ` TO  NEXT  ROW  `
Continue matching after the first row of the current match.
This allows matches that contain overlapping rows. For example, if you have a
stock pattern that contains 3 ` V  ` shapes in a row, then ` TO  NEXT  ROW  `
finds two ` W  ` patterns (the first pattern is based on the first two ` V  `
shapes, and the second ` W  ` shape is based on the second and third ` V  `
shapes; thus both patterns contain the same ` V  ` ).
  * ` TO  [  {  FIRST  |  LAST  }  ]  <symbol> `
Continue matching at the first or last (default) row that was matched to the
given symbol.
At least one row needs to be mapped to the given symbol or an error is raised.
If this does not skip past the first row of the current match, then an error
is raised.
Syntax  ¶
    GET internalStage file://<local_directory_path>
        [ PARALLEL = <integer> ]
        [ PATTERN = '<regex_pattern>'' ]
Copy
Where:
>
>     internalStage ::=
>         @[<namespace>.]<int_stage_name>[/<path>]
>       | @[<namespace>.]%<table_name>[/<path>]
>       | @~[/<path>]
>  
>
> Copy
Syntax  ¶
    CREATE [ OR REPLACE ] EXTERNAL VOLUME [IF NOT EXISTS]
      <name>
      STORAGE_LOCATIONS =
        (
          (
            NAME = '<storage_location_name>'
            cloudProviderParams
          )
          [, (...), ...]
        )
      [ ALLOW_WRITES = { TRUE | FALSE }]
      [ COMMENT = '<string_literal>' ]
Copy
Where:
>
>     cloudProviderParams (for Amazon S3) ::=
>       STORAGE_PROVIDER = 'S3'
>       STORAGE_AWS_ROLE_ARN = '<iam_role>'
>       STORAGE_BASE_URL = 's3://<bucket>[/<path>/]'
>       [ STORAGE_AWS_EXTERNAL_ID = '<external_id>' ]
>       [ ENCRYPTION = ( [ TYPE = 'AWS_SSE_S3' ] |
>                   [ TYPE = 'AWS_SSE_KMS' [ KMS_KEY_ID = '<string>' ] ] |
>                   [ TYPE = 'NONE' ] ) ]
>  
>
> Copy
>  
>  
>     cloudProviderParams (for Google Cloud Storage) ::=
>       STORAGE_PROVIDER = 'GCS'
>       STORAGE_BASE_URL = 'gcs://<bucket>[/<path>/]'
>       [ ENCRYPTION = ( [ TYPE = 'GCS_SSE_KMS' ] [ KMS_KEY_ID = '<string>' ]
> |
>                   [ TYPE = 'NONE' ] ) ]
>  
>
> Copy
>  
>  
>     cloudProviderParams (for Microsoft Azure) ::=
>       STORAGE_PROVIDER = 'AZURE'
>       AZURE_TENANT_ID = '<tenant_id>'
>       STORAGE_BASE_URL =
> 'azure://<account>.blob.core.windows.net/<container>[/<path>/]'
>  
>
> Copy
Syntax  ¶
    EXECUTE IMMEDIATE
      FROM { absoluteFilePath | relativeFilePath }
Copy
Where:
>
>     absoluteFilePath ::=
>        @[ <namespace>. ]<stage_name>/<path>/<filename>
>  
>
> Copy
>  
>  
>     relativeFilePath ::=
>       '[ { ./ | / | { ../ [ , ../, ... ] } } ]<path>/<filename>'
>  
>
> Copy
Syntax  ¶
    REMOVE { internalStage | externalStage } [ PATTERN = '<regex_pattern>' ]
Copy
Where:
>
>     internalStage ::=
>         @[<namespace>.]<int_stage_name>[/<path>]
>       | @[<namespace>.]%<table_name>[/<path>]
>       | @~[/<path>]
>  
>
> Copy
>  
>  
>     externalStage ::=
>         @[<namespace>.]<ext_stage_name>[/<path>]
>  
>
> Copy
Syntax  ¶
    ALTER EXTERNAL TABLE [ IF EXISTS ] <name> REFRESH [ '<relative-path>' ]
    ALTER EXTERNAL TABLE [ IF EXISTS ] <name> ADD FILES ( '<path>/[<filename>]' [ , '<path>/[<filename>'] ] )
    ALTER EXTERNAL TABLE [ IF EXISTS ] <name> REMOVE FILES ( '<path>/[<filename>]' [ , '<path>/[<filename>]' ] )
    ALTER EXTERNAL TABLE [ IF EXISTS ] <name> SET AUTO_REFRESH = { TRUE | FALSE }
Copy
**Partitions added and removed manually**
>
>     ALTER EXTERNAL TABLE <name> [ IF EXISTS ] ADD PARTITION (
> <part_col_name> = '<string>' [ , <part_col_name> = '<string>' ] ) LOCATION
> '<path>'
>  
>     ALTER EXTERNAL TABLE <name> [ IF EXISTS ] DROP PARTITION LOCATION
> '<path>'
>  
>
> Copy