1.08 TARGET TABLES
8.1 List of Target Tables SELECT B.SUBJ_NAME, A.TARGET_NAME, DECODE(A.DBTYPE, 0,’VSAM’, 1,’IMS’, 2,’Sybase’, 3,’Oracle’, 4,’Informix’, 5,’Microsoft SQL Server’, 6,’DB2′, 7,’Flat File’, 8,’ODBC’, 9,’SAP BW’, 10,’PeopleSoft’, 11,’SAP R/3′, 12,’XML’, 13,’MQSeries’, 14,’Siebel’, 15,’Teradata’ ) as DB_TYPE FROM OPB_TARG A, OPB_SUBJECT B WHERE A.SUBJ_ID = B.SUBJ_ID ORDER BY 1,2,3 8.2 List All Columns, DB, Length of a Target Table […]
1.11 Mapplets
11.1 List Mapplets in all folders select subject_area,mapplet_name from rep_all_mapplets order by 1,2 11.2 List Mapplet parameters and variables select distinct rep_reposit_info.repository_name, rep_all_mapplets.subject_area as folder_name, rep_all_mapplets.mapplet_name as object_name, case when opb_map_parmvar.pv_flag = 2 then ‘Mapplet Parameter’ else case when opb_map_parmvar.pv_flag = 3 then ‘Mapplet Variable’ end end as parameter_type, opb_map_parmvar.pv_name as parameter_name, opb_map_parmvar.pv_default as parameter_value, […]
1.10 Mappings
10.1 List mapping names SELECT SUBJECT_AREA, PARENT_MAPPING_NAME FROM REP_ALL_MAPPINGS ORDER BY 1, 2 10.2 List total count of mappings SELECT SUBJECT_AREA, COUNT(PARENT_MAPPING_NAME) AS TOTAL_MAPPINGS FROM REP_ALL_MAPPINGS GROUP BY SUBJECT_AREA ORDER BY 1, 2 10.3 List last saved user for a mapping SELECT REP_SUBJECT.SUBJECT_AREA “FOLDER”,REP_VERSION_PROPS.OBJECT_NAME “MAPPING”, REP_USERS.USER_NAME,REP_VERSION_PROPS.LAST_SAVED FROM REP_USERS,REP_VERSION_PROPS,REP_SUBJECT WHERE REP_USERS.USER_ID=REP_VERSION_PROPS.USER_ID AND REP_VERSION_PROPS.OBJECT_TYPE IN (21) –AND […]
Introduction to AWS: The Powerhouse of Cloud Computing
In the rapidly evolving world of technology, businesses and developers alike are constantly seeking ways to enhance efficiency, scalability, and innovation. Enter Amazon Web Services (AWS), a comprehensive and widely adopted cloud platform that offers a vast array of services and solutions designed to meet the diverse needs of organizations of all sizes. Whether you’re […]
Understanding Snowflake Queries and Credit Usage
As data grows at an unprecedented rate, businesses increasingly rely on advanced cloud data platforms to manage and analyze their data efficiently. Snowflake has emerged as a leading cloud-based data warehousing solution, offering scalable and flexible data storage and analytics capabilities. One key aspect of using Snowflake effectively is understanding how queries affect credit usage, […]
5. Snowflake vs Oracle
Snowflake vs Oracle Data type Conversion Refer to Snowflake Documentation for more details.
3. Snowflake Dashboard Queries – Credits Usage
// Query : 1. WH Credits by Month // Query 2 : WH Credits by Week // Query 3 : WH Credits by Month (Top 10) // Query 4 : WH Credits by Week (Top 10) // Query 5 : WH Credits used last 30 days // Query 6 : Top users by Execution Time […]
4. Snowflake Single Sign On Configuration
In Snowflake, we can setup either below two methods. Service provider (SP): In a Snowflake federated environment, Snowflake serves as the SP. Identity provider (IdP): The external, independent entity responsible for providing the following services to the SP: Creating and maintaining user credentials and other profile information. Authenticating users for SSO access to the SP. […]
2. Snowflake Account Queries
Step 1 : Create Warehouse Step 2 : Create Database Step 3 : Create Database Roles Step 4 : Create Account Level Roles Step 5 : Grant Roles to SYSADMIN Step 6 : Grant to DB Roles Step 7 : Create Schema and provide Grants
1. Snowflake Account Setup
In this sessions we will start by discussing setting up a Snowflake account, especially for those new to the Snowflake. With a Snowflake account readily available and a limited understanding of its system-defined roles, it usually becomes a challenge for a team lead or an admin to set up the environments with proper access controls to […]