BEGIN; in Snowflake SQL vs BEGIN END; in Snowflake Scripting – Snowflake Scripting and transactions

Posted on 29 November 2022 by Przemysław Kantyka

In this post I would like to highlight some aspects of using Snowflake Scripting and how it relates to Snowflake transactions. We will see some rather fundamental information here, but even an experienced developer can find interesting information, especially since Snowflake’s behavior sometimes differs from what we have in other DB systems (such as Oracle). We will start by comparing the BEGIN; statement with the BEGIN keyword in Snowflake Scripting. We will also see how the AUTOCOMMIT mechanism works and how to get around it when programming in Snowflake Scripting. At the end of the post, we will see the concept of scoped transactions and its effects in an example scenario.
Continue reading →

Posted in Snowflake, Snowflake Scripting, Snowflake SQL | Tagged , , , , | Comments Off on BEGIN; in Snowflake SQL vs BEGIN END; in Snowflake Scripting – Snowflake Scripting and transactions

Working with Snowflake using the Vertex AI platform

Posted on 18 October 2022 by Rafal Stryjek

Google Cloud Platform created the Vertex AI as the unified platform to build and deploy machine learning models. It enables a widely discussed MLOps approach that improves modelling by using DevOps and data engineering methods. Wouldn’t it be an ideal situation if you could integrate Vertex AI with Snowflake?

Working with Snowflake using the Vertex AI platform diagram

Continue reading →

Posted in GCP, pySpark, Snowflake, Snowpark, Vertex AI | Tagged , , , | Comments Off on Working with Snowflake using the Vertex AI platform

Oracle CDC to Snowlake Data Cloud using Amazon DMS and Snowpipe

Posted on 22 September 2022 by Rafal Stryjek

Oracle CDC to Snowflake using Amazon DMS and Snowpipe

Sometimes it might be said that you would like to benefit from both a classic Oracle database and as well from Snowflake Data Cloud. For instance, your target architecture assumes OLTP workloads to be run in Oracle while typical DWH workloads (reporting, analytics, ad-hoc queries) is run in Snowflake Data Cloud.

Continue reading →

Posted in AWS, AWS DMS, CDC, Oracle, Snowflake | Tagged , , | Comments Off on Oracle CDC to Snowlake Data Cloud using Amazon DMS and Snowpipe

3 ways how to connect Oracle to Snowflake – the technical overview

Posted on 11 June 2021 by Rafal Stryjek

Wouldn’t it be great if you could bring Snowflake into the Oracle database ecosystem? Or, you may need to add Oracle database to the Snowflake ecosystem. What about pushing down the Oracle database ETL to the Snowflake layer?  Or maybe, you have Oracle legacy system and you want to query Oracle data from Snowflake with all changes in data visible in real time. And finally, would you like to incorporate Snowflake data into Oracle PL/SQL ETL code?

Let’s take a look at 3 ways how to connect Oracle to Snowflake.

Continue reading →

Posted in Oracle, Snowflake | Tagged , , , , | Comments Off on 3 ways how to connect Oracle to Snowflake – the technical overview

APEX Connect 2021

Posted on 3 May 2021 by Przemysław Kantyka

We are glad to announce, that we will be present on APEX Connect 2021

Continue reading →

Posted in Nieokreślona | Comments Off on APEX Connect 2021

Funkcja agregująca COLLECT – część pierwsza

Posted on 31 March 2021 by Rafal Stryjek

W tym wpisie przyjrzymy się funkcji agregującej COLLECT. Funkcja ta przyjmuje jako argument kolumnę, zwracając w wyniku zagnieżdżoną tabelę dla każdej grupy, po której odbywa się grupowanie. Tabela ta zawiera wiersze złożone z wartości kolumny, która została podana jako argument. Wiersze zawarte w zagnieżdżonej tabeli, przynależą do grupy, dla której wywołana została funkcja (rys. 1.)  

Continue reading →

Posted in Oracle, Oracle APEX, Oracle SQL, Oracle SQL Zaawansowany | Tagged , | Comments Off on Funkcja agregująca COLLECT – część pierwsza

Analytic SQL | Snowflake

Posted on 21 October 2020 by Rafal Stryjek

Analytic SQL Examples: Download

 

Posted in Snowflake | Comments Off on Analytic SQL | Snowflake

Expose Big Data using the Oracle Application Express (APEX)

Posted on 10 October 2019 by Rafal Stryjek

In this article we will describe how to expose Big Data in Oracle Application Express (APEX) using tools/mechanisms provided by Oracle.

Examples are based on:

  • Oracle Big Data Lite Virtual Machine – For testing and educational purposes only you can get Big Data Lite virtual machine here.
  • Examples in this article are based on data from the Department of Transportation (DOT):  https://www.transtats.bts.gov. Please download csv file from here: Prezipped file for January 2018.
Continue reading →
Posted in Nieokreślona | Tagged , , , , , , | Comments Off on Expose Big Data using the Oracle Application Express (APEX)

Load Balancer with Oracle APEX in the Amazon Cloud (AWS)

Posted on 14 September 2019 by Przemysław Kantyka

We provide multiple products related to Oracle APEX in the AWS Amazon Marketplace. One of this product allows you to run Oracle APEX and ORDS on top of Oracle Standard Edition with license provided by Amazon in Pay-As-you-Go model. Our product: Oracle APEX 19c with ORDS 19.1 for Amazon Oracle RDS on CentOS 7 bundles ORDS, Tomcat, APEX 19c and other software components in single AMI pre-configured for usage with external Amazon RDS for Oracle

Due to fact that database instance is external to ORDS/APEX/Tomcat instance there is possibility to run multiple ORDS linked to single database. It allows you to serve your APEX application by multiple ORDS instances connected to single database. There are dedicated Amazon AWS settings in EC2 dashboard called Load Balancer that can cooperate with multiple instances of
Oracle APEX 19c with ORDS 19.1 for Amazon Oracle RDS on CentOS 7 to leverage traffic.

At the end architecture for load balancing would look like that:

Continue reading →
Posted in Amazon AWS Marketplace, AWS, Oracle APEX, Oracle APEX Advanced, Oracle DBA | Tagged , , , , , , | Comments Off on Load Balancer with Oracle APEX in the Amazon Cloud (AWS)

svnAPEX BETA demo server is public now

Posted on 28 August 2019 by Przemysław Kantyka

We’ve published svnAPEX BETA version (aka APEX Version Control) on our public DEMO server.

svnAPEX allows you to follow industry standard workflow and increase efficiency of your APEX development process by integration the Application Builder with SVN version control system. To find more about our tool see http://datacons.co.uk/apex-version-control/. To get access to DEMO server – continue reading please.

Our DEMO server allows you to check functionality of svnAPEX tool, see its behavior and review interface.

Continue reading →

Posted in Oracle APEX, Oracle APEX Advanced | Tagged , , , , , , | Comments Off on svnAPEX BETA demo server is public now