[L:  1, P:  1]      |file:
[L:  1, P:  1]      |    multi_statement_segment:
[L:  1, P:  1]      |        create_procedure_statement:
[L:  1, P:  1]      |            keyword:                                          'CREATE'
[L:  1, P:  7]      |            whitespace:                                       ' '
[L:  1, P:  8]      |            keyword:                                          'OR'
[L:  1, P: 10]      |            whitespace:                                       ' '
[L:  1, P: 11]      |            keyword:                                          'REPLACE'
[L:  1, P: 18]      |            whitespace:                                       ' '
[L:  1, P: 19]      |            keyword:                                          'PROCEDURE'
[L:  1, P: 28]      |            whitespace:                                       ' '
[L:  1, P: 29]      |            procedure_name:
[L:  1, P: 29]      |                naked_identifier:                             'place_name'
[L:  1, P: 39]      |                dot:                                          '.'
[L:  1, P: 40]      |                procedure_name_identifier:                    'proc_name'
[L:  1, P: 49]      |            newline:                                          '\n'
[L:  2, P:  1]      |            procedure_parameter_list:
[L:  2, P:  1]      |                bracketed:
[L:  2, P:  1]      |                    start_bracket:                            '('
[L:  2, P:  2]      |                    [META] indent:
[L:  2, P:  2]      |                    newline:                                  '\n'
[L:  3, P:  1]      |                    whitespace:                               '    '
[L:  3, P:  5]      |                    parameter:                                '_log'
[L:  3, P:  9]      |                    whitespace:                               ' '
[L:  3, P: 10]      |                    data_type:
[L:  3, P: 10]      |                        struct_type:
[L:  3, P: 10]      |                            keyword:                          'STRUCT'
[L:  3, P: 16]      |                            struct_type_schema:
[L:  3, P: 16]      |                                start_angle_bracket:          '<'
[L:  3, P: 17]      |                                [META] indent:
[L:  3, P: 17]      |                                newline:                      '\n'
[L:  4, P:  1]      |                                whitespace:                   '        '
[L:  4, P:  9]      |                                parameter:                    'Process_ID'
[L:  4, P: 19]      |                                whitespace:                   '             '
[L:  4, P: 32]      |                                data_type:
[L:  4, P: 32]      |                                    data_type_identifier:     'STRING'
[L:  4, P: 38]      |                                newline:                      '\n'
[L:  5, P:  1]      |                                whitespace:                   '        '
[L:  5, P:  9]      |                                comma:                        ','
[L:  5, P: 10]      |                                parameter:                    'Debug'
[L:  5, P: 15]      |                                whitespace:                   '                 '
[L:  5, P: 32]      |                                data_type:
[L:  5, P: 32]      |                                    data_type_identifier:     'INT64'
[L:  5, P: 37]      |                                newline:                      '\n'
[L:  6, P:  1]      |                                whitespace:                   '        '
[L:  6, P:  9]      |                                [META] dedent:
[L:  6, P:  9]      |                                end_angle_bracket:            '>'
[L:  6, P: 10]      |                    newline:                                  '\n'
[L:  7, P:  1]      |                    [META] dedent:
[L:  7, P:  1]      |                    end_bracket:                              ')'
[L:  7, P:  2]      |            newline:                                          '\n'
[L:  8, P:  1]      |            newline:                                          '\n'
[L:  9, P:  1]      |            keyword:                                          'BEGIN'
[L:  9, P:  6]      |            [META] indent:
[L:  9, P:  6]      |            newline:                                          '\n'
[L: 10, P:  1]      |            newline:                                          '\n'
[L: 11, P:  1]      |            inline_comment:                                   '-- Declaration'
[L: 11, P: 15]      |            newline:                                          '\n'
[L: 12, P:  1]      |            newline:                                          '\n'
[L: 13, P:  1]      |            procedure_statements:
[L: 13, P:  1]      |                statement:
[L: 13, P:  1]      |                    declare_segment:
[L: 13, P:  1]      |                        keyword:                              'DECLARE'
[L: 13, P:  8]      |                        whitespace:                           ' '
[L: 13, P:  9]      |                        naked_identifier:                     '_Source_Table'
[L: 13, P: 22]      |                        whitespace:                           '       '
[L: 13, P: 29]      |                        data_type:
[L: 13, P: 29]      |                            data_type_identifier:             'STRING'
[L: 13, P: 35]      |                statement_terminator:                         ';'
[L: 13, P: 36]      |                newline:                                      '\n'
[L: 14, P:  1]      |                newline:                                      '\n'
[L: 15, P:  1]      |                statement:
[L: 15, P:  1]      |                    create_table_statement:
[L: 15, P:  1]      |                        keyword:                              'CREATE'
[L: 15, P:  7]      |                        whitespace:                           ' '
[L: 15, P:  8]      |                        keyword:                              'OR'
[L: 15, P: 10]      |                        whitespace:                           ' '
[L: 15, P: 11]      |                        keyword:                              'REPLACE'
[L: 15, P: 18]      |                        whitespace:                           ' '
[L: 15, P: 19]      |                        keyword:                              'TEMP'
[L: 15, P: 23]      |                        whitespace:                           ' '
[L: 15, P: 24]      |                        keyword:                              'TABLE'
[L: 15, P: 29]      |                        whitespace:                           ' '
[L: 15, P: 30]      |                        table_reference:
[L: 15, P: 30]      |                            naked_identifier:                 '_SESSION'
[L: 15, P: 38]      |                            dot:                              '.'
[L: 15, P: 39]      |                            naked_identifier:                 '__Calendar_Target_Buffer'
[L: 15, P: 63]      |                        newline:                              '\n'
[L: 16, P:  1]      |                        bracketed:
[L: 16, P:  1]      |                            start_bracket:                    '('
[L: 16, P:  2]      |                            [META] indent:
[L: 16, P:  2]      |                            whitespace:                       ' '
[L: 16, P:  3]      |                            newline:                          '\n'
[L: 17, P:  1]      |                            whitespace:                       '    '
[L: 17, P:  5]      |                            column_definition:
[L: 17, P:  5]      |                                naked_identifier:             'some_id'
[L: 17, P: 12]      |                                whitespace:                   ' '
[L: 17, P: 13]      |                                data_type:
[L: 17, P: 13]      |                                    data_type_identifier:     'int64'
[L: 17, P: 18]      |                            newline:                          '\n'
[L: 18, P:  1]      |                            [META] dedent:
[L: 18, P:  1]      |                            end_bracket:                      ')'
[L: 18, P:  2]      |                statement_terminator:                         ';'
[L: 18, P:  3]      |                newline:                                      '\n'
[L: 19, P:  1]      |                newline:                                      '\n'
[L: 20, P:  1]      |                statement:
[L: 20, P:  1]      |                    set_segment:
[L: 20, P:  1]      |                        keyword:                              'SET'
[L: 20, P:  4]      |                        whitespace:                           ' '
[L: 20, P:  5]      |                        naked_identifier:                     '_Metric_ID'
[L: 20, P: 15]      |                        whitespace:                           ' '
[L: 20, P: 16]      |                        comparison_operator:
[L: 20, P: 16]      |                            raw_comparison_operator:          '='
[L: 20, P: 17]      |                        whitespace:                           ' '
[L: 20, P: 18]      |                        numeric_literal:                      '1001'
[L: 20, P: 22]      |                statement_terminator:                         ';'
[L: 20, P: 23]      |                newline:                                      '\n'
[L: 21, P:  1]      |                newline:                                      '\n'
[L: 22, P:  1]      |                inline_comment:                               '-- define metric details'
[L: 22, P: 25]      |                newline:                                      '\n'
[L: 23, P:  1]      |                statement:
[L: 23, P:  1]      |                    call_statement:
[L: 23, P:  1]      |                        keyword:                              'CALL'
[L: 23, P:  5]      |                        whitespace:                           ' '
[L: 23, P:  6]      |                        procedure_name:
[L: 23, P:  6]      |                            naked_identifier:                 'some_place'
[L: 23, P: 16]      |                            dot:                              '.'
[L: 23, P: 17]      |                            procedure_name_identifier:        'some_name1'
[L: 23, P: 27]      |                        whitespace:                           ' '
[L: 23, P: 28]      |                        bracketed:
[L: 23, P: 28]      |                            start_bracket:                    '('
[L: 23, P: 29]      |                            [META] indent:
[L: 23, P: 29]      |                            newline:                          '\n'
[L: 24, P:  1]      |                            whitespace:                       '    '
[L: 24, P:  5]      |                            expression:
[L: 24, P:  5]      |                                column_reference:
[L: 24, P:  5]      |                                    naked_identifier:         '_Some_ID'
[L: 24, P: 13]      |                            [META] dedent:
[L: 24, P: 13]      |                            end_bracket:                      ')'
[L: 24, P: 14]      |                statement_terminator:                         ';'
[L: 24, P: 15]      |                newline:                                      '\n'
[L: 25, P:  1]      |                newline:                                      '\n'
[L: 26, P:  1]      |                unparsable:                                   !! Expected: "Nothing else before ' '"
[L: 26, P:  1]      |                    word:                                     'IF'
[L: 26, P:  3]      |                    whitespace:                               ' '
[L: 26, P:  4]      |                    word:                                     '_log'
[L: 26, P:  8]      |                    dot:                                      '.'
[L: 26, P:  9]      |                    word:                                     'Debug'
[L: 26, P: 14]      |                    whitespace:                               ' '
[L: 26, P: 15]      |                    equals:                                   '='
[L: 26, P: 16]      |                    whitespace:                               ' '
[L: 26, P: 17]      |                    numeric_literal:                          '1'
[L: 26, P: 18]      |                    whitespace:                               ' '
[L: 26, P: 19]      |                    word:                                     'THEN'
[L: 26, P: 23]      |                    newline:                                  '\n'
[L: 27, P:  1]      |                    whitespace:                               '\t'
[L: 27, P:  2]      |                    word:                                     'SELECT'
[L: 27, P:  8]      |                    whitespace:                               ' '
[L: 27, P:  9]      |                    word:                                     '_SQL'
[L: 27, P: 13]      |                    semicolon:                                ';'
[L: 27, P: 14]      |                    newline:                                  '\n'
[L: 28, P:  1]      |                    word:                                     'ELSE'
[L: 28, P:  5]      |                    newline:                                  '\n'
[L: 29, P:  1]      |                    whitespace:                               '    '
[L: 29, P:  5]      |                    word:                                     'SELECT'
[L: 29, P: 11]      |                    whitespace:                               ' '
[L: 29, P: 12]      |                    word:                                     '_SQL'
[L: 29, P: 16]      |                    semicolon:                                ';'
[L: 29, P: 17]      |            whitespace:                                       ' '
[L: 29, P: 18]      |            newline:                                          '\n'
[L: 30, P:  1]      |            [META] dedent:
[L: 30, P:  1]      |            keyword:                                          'END'
[L: 30, P:  4]      |    whitespace:                                               ' '
[L: 30, P:  5]      |    unparsable:                                               !! Expected: 'Nothing else in FileSegment.'
        Comments:
[L: 32, P:  1]      |            inline_comment:                                   '--end try'
        Code:
[L: 30, P:  5]      |            word:                                             'IF'
[L: 30, P:  7]      |            semicolon:                                        ';'
[L: 30, P:  8]      |            newline:                                          '\n'
[L: 31, P:  1]      |            newline:                                          '\n'
[L: 32, P: 10]      |            newline:                                          '\n'
[L: 33, P:  1]      |            word:                                             'END'
[L: 33, P:  4]      |            semicolon:                                        ';'
[L: 33, P:  5]      |    [META] end_of_file:

==== parsing violations ====
L:  26 | P:   1 |  PRS | Line 26, Position 1: Found unparsable section: 'IF _log.Debug = 1
                       | THEN\n\tSELECT _SQL;\nELS...'
L:  30 | P:   5 |  PRS | Line 30, Position 5: Found unparsable section: 'IF;\n\n--end
                       | try\nEND;'
WARNING: Parsing errors found and dialect is set to 'bigquery'. Have you configured your dialect correctly?