ericlin.me Open in urlscan Pro
2606:4700:3032::6815:1a74  Public Scan

Form analysis
2 forms found in the DOM

GET https://snowflake.ericlin.me/

<form role="search" method="get" class="search-form" action="https://snowflake.ericlin.me/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="search-submit" value="Search">
</form>

GET https://snowflake.ericlin.me/

<form role="search" method="get" class="search-form" action="https://snowflake.ericlin.me/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="search-submit" value="Search">
</form>

Text Content

Skip to content


SNOWFLAKE GUIDE

Eric's another Big Data Blog

Primary Menu
 * Home
 * About Me
 * |
 * SQL
 * Security
 * JDBC



Search for:


STRING OBJECT IN JAVASCRIPT UDF DOES NOT HAVE THE REPLACEALL() FUNCTION

Posted on 5 November 20215 November 2021 by Eric Lin

When trying to use replaceAll() function from a String object in Snowflake’s
Javascipt UDF, it will fail with the below error message: Based on the
information on Wikipedia, the string function replaceAll() was released in June
2021, with 12th Edition – ECMAScript 2021.  Since this is a new function, it has
not been incorporated into Snowflake’s Javascript library. […]






Continue Reading


CREATE VIEW AUTOMATICALLY FROM VARIANT COLUMNS

Posted on 30 October 202130 October 2021 by Eric Lin

Recently I was helping one of the StackOverflow users to resolve one of his/her
problems. The question was whether Snowflake has any way of automatically
creating views on top of a table that has a variant data type, so that users can
access data inside the variant just like a normal column. I do not […]






Continue Reading


FIND CHILD QUERIES OF A STORED PROCEDURE

Posted on 28 October 202128 October 2021 by Eric Lin

Currently Snowflake does not show the parent and child relationships between
executed Stored Procedure and queries triggered from within the Stored Procedure
from the QUERY_HISTORY view. This is quite an inconvenience if we want to find
out what are the queries triggered by a certain Stored Procedure. I found a
workaround to this issue, though […]






Continue Reading


JAVASCRIPT UDF FAILS WITH ERROR: TIME INSIDE VARIANT VALUE – NOT SUPPORTED

Posted on 24 May 202124 May 2021 by Eric Lin

When running Javascript UDF with VARIANT data type passed into it as parameter,
it fails with error: TIME inside VARIANT value – not supported This issue can be
reproduced using below steps: And the last SELECT statement will fail with above
mentioned error. This is because Javascript does not support the TIME data type,
as […]






Continue Reading


NANO SECOND PRECISION LOST AFTER PARQUET FILE UNLOAD

Posted on 24 May 202124 May 2021 by Eric Lin

When unloading Timestamp data into Parquet file, the nano and micro seconds
precision will be lost, and only milliseconds are stored in the file.  To
reproduce the issue, please see below script: We can see that the nano seconds
part .12434453 was truncated to .124. This is due to limitations on Parquet V1
that is currently being used […]






Continue Reading


STORED PROCEDURE FAILS WITH ERROR “REQUESTED INFORMATION ON THE CURRENT USER IS
NOT ACCESSIBLE IN STORED PROCEDURE”

Posted on 19 May 202124 May 2021 by Eric Lin

When running a Stored Procedure that triggers a query to run against Views or
Functions from INFORMATION_SCHEMA, it might fail with below error message:
Requested information on the current user is not accessible in stored procedure.
This can be easily reproduced using below code: The reason for the failure is
because for the owner’s right […]






Continue Reading


TIMESTAMP FUNCTION RETURNS DIFFERENT RESULTS WHEN SORTED BY DIFFERENT DIRECTION

Posted on 21 February 202124 May 2021 by Eric Lin

Recently, I was working on an issue for customer who faced a weird behaviour
that TIMESTAMP conversion function returned different results if different
sorting direction was used, meaning, results are different if using ASC vs DESC.
To illustrate the issue, please see my test case below: Create a table with
testing data: 2. Run below […]






Continue Reading


FILE PRUNING FOR EXTERNAL TABLES

Posted on 18 February 202124 May 2021 by Eric Lin

Currently Snowflake does not support pruning External Table files. To prove it,
I have performed below test. Assume that I have an external S3 stage setup
correctly, which points to an external S3 location with a few CSV files, I
create below external table: The stage @ERICLIN_S3_STAGE/test contains a list of
CSV files And each […]






Continue Reading


DECIMAL VALUES ARE CONVERTED TO INTEGER VALUES

Posted on 25 January 202124 May 2021 by Eric Lin

Today, I have learnt that Snowflake will convert decimal values to integer
values if all trailings are zeros. Please see below examples: It returns: The
same applies to PARSE_JSON: It returns: Instead of: After researching with our
team, it turned out that it was expected behaviour. In fact, Snowflake has been
behaving this way for […]






Continue Reading


QUERY AGAINST PARQUET FILE FAILED WITH ERROR “NOT YET IMPLEMENTED: UNSUPPORTED
ENCODING”

Posted on 20 January 202124 May 2021 by Eric Lin

Recently I was dealing with an issue that a Snowflake query against Parquet file
in internal Staging failed with error as below: After researching online, I
figured out that it was nothing to do with Snowflake, it was because user
used AWS Cost and Usage Report (CUR) tool to generate the Parquet file, which
contains a version of […]






Continue Reading


POSTS NAVIGATION

Older post:
Eric Lin
Principal Cloud Support Engineer
@ Snowflake
Blogger | Runner | Ex-Cloudera
3 x SnowPro
Snowflake | Monash University
View Profile
Search for:



FRIENDLY LINKS

 * Cloudera Troubleshooting
 * RAYNIX 筆記


RECENT POSTS

 * String object in Javascript UDF does not have the replaceAll() function
 * Create View Automatically From VARIANT Columns
 * Find Child Queries of a Stored Procedure
 * JavaScript UDF fails with error: TIME inside VARIANT value – not supported
 * Nano second precision lost after Parquet file Unload

All rights reserved!
Copyright All rights reserved | Theme: Advance Blog by WPinterface.