Author Archives: Rafal Stryjek

About Rafal Stryjek

My LinkedIn profile. Passionate about data. Data Warehousing Expert. Snowflake Data SuperHero & Oracle ACE Associate Alumni. International conferences Speaker: Snowflake Build Summit-BUILD.local 2021, Oracle Open World, DOAG, UKOUG, APEX World,.. Visit dataconsulting.pl website!

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 … 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 … 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, … Continue reading →

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

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 … 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 … Continue reading →

Posted in Nieokreślona | Tagged , , , , , , | Comments Off on Expose Big Data using the Oracle Application Express (APEX)

Co nowego w Oracle 12.2 – Identyfikatory powyżej 30 znaków?

Posted on 9 November 2016 by Rafal Stryjek

“The maximum length of identifiers is increased to 128 bytes for most identifiers, up from 30 bytes in previous releases” Brzmi ciekawie 😉

Posted in Oracle, Oracle DBA, Oracle DBA Basic, Oracle SQL, Oracle SQL Zaawansowany | Tagged , | Leave a comment

Oracle 12.2 – dokumentacja

Posted on 8 November 2016 by Rafal Stryjek

Ukazała się dokumentacja do Oracle 12.2. Możemy zapoznać się między innymi z nowymi cechami 12.2, dzięki “What’s new”. http://docs.oracle.com/database/122/index.htm

Posted in Oracle, Oracle SQL, PL/SQL | Tagged , | Leave a comment

Connect by level vs recursive with (CTE) for generating values

Posted on 10 April 2016 by Rafal Stryjek

Hi All, Have you ever wondered what is the difference between generating records using connect by level and recursive with in CTE (available from Oracle 11R2)? I did short ora-investigation 🙂

Posted in Oracle, Oracle DBA, Oracle DBA Basic, Oracle SQL, Oracle SQL Tuning | Tagged , , , | Leave a comment

Profilowanie zawrapowanego kodu PL/SQL

Posted on 15 March 2016 by Rafal Stryjek

Czy zastanawialiście się co stanie się, gdy spróbujcie profilować zawrapowany kod PL/SQL? Czy dowiemy się jakie nr linii kosztują nas najbardziej? Czy dowiemy się jakie funkcje i procedury uruchamia nas zawrapowany kod? Jeśli tak – zapraszam do lektury 🙂

Posted in Oracle, PL/SQL, PL/SQL Zaawansowany | Tagged , , , , , | Leave a comment