You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@beam.apache.org by Jaehyeon Kim <do...@gmail.com> on 2024/03/04 05:14:29 UTC

How to change SQL dialect on beam_sql magic?

Hello,

beam_sql magic doesn't seem to have an option to specify an SQL dialect
while the underlying SqlTransform has the dialect argument. Is there a way
to specify an SQL dialect on a notebook?

Cheers,
Jaehyeon

[image: image.png]

Re: How to change SQL dialect on beam_sql magic?

Posted by XQ Hu via user <us...@beam.apache.org>.

I do not think the dialect argument is exposed here:
https://github.com/apache/beam/blob/a391198b5a632238dc4a9298e635bb5eb0f433df/sdks/python/apache_beam/runners/interactive/sql/beam_sql_magics.py#L293

Two options:
1) create a feature request and PR to add that
2) Switch to SqlTransform

On Mon, Mar 4, 2024 at 12:14 AM Jaehyeon Kim <do...@gmail.com> wrote:

> Hello,
>
> beam_sql magic doesn't seem to have an option to specify an SQL dialect
> while the underlying SqlTransform has the dialect argument. Is there a way
> to specify an SQL dialect on a notebook?
>
> Cheers,
> Jaehyeon
>
> [image: image.png]
>