Data

Page tree



Knowledge Base

Welcome to the Knowledge Base page. The purpose of this page is to share the knowledge gained from product and service resources found by Subject Matter Experts and materials found by users to CCSQ data analytics users. 

Users that have any suggestions or comments related to the Knowledge Base page should contact the CCSQ Data & Analytics Team. 

Knowledge Base

BIC Data Questions from CCSQ Users

Data Catalog

How to Access HQR Read-Replica Database Through SAS Viya

How to Verify Access to CDR Data

MDM 3.0 Cloud Migration - Changes and Workarounds

Consolidation of Tables and Databases in the Centralized Data Repository Lakehouse

Transitioning from Ambari to Databricks 

Databricks Languages Overview

DBX Code Migration Considerations

How to Connect to Databricks Using SAS

Connecting SAS BYOA/BYOD to DBX SQL

Introduction to Databricks Notebook

Tips to Debug Apache Spark

Debugging in Databricks Notebooks

Debugging with the Apache Spark UI

Manage Scheduled Notebook Jobs

Copy Zeppelin Notebook to Databricks

Selecting an R Cluster

Best Practices for DataFrame

Macro To Convert SAS Files to Databricks

How to Connect to Hadoop

How to Convert Time Zones in Hive

How to Create a SQL Macro Variable Using HiveQL Syntax

How to Emulate PROC Format in Hive

How to Create Flag Fields with Hive Arrays

How to Move Data from Hive to Workbench

How to Read Text Files from SAS Viya into a Native SAS Dataset

How to Sort in SAS Viya vs. HIVE

How to Stop all Hive Jobs Spawned by Interactive SAS Session

How to Write an Explicit Hive Queries and Explicit SQL Passthrough

Improving HIVE Query Performance

List of Hive Functions

Hive Execution Plan

How to Use Partition Pruning in your Hive Queries

Performance Impacting Hive Functions

SAS PROCs that Support Hive

QuickSight: The Basics

How To Create a Dataset Joining Two Existing Data Sources

How To Create a Dashboard With a Single Visualization

How To Create a Drill-Down/Up

How To Create a Filter Control

How To Create Custom Action to Link Dashboards & Pass Parameters

How To Optimal Dashboard Publishing

How To Share a Dashboard

How To Use Tabs/Sheets

How To Use Parameters to Create Dynamic Titles & Descriptions

How to Create a Scheduled Job in SAS Viya 3.5

How to Reset User Preferences to Default

How to Save CASLIB Data prior to Maintenance

How to Utilize Global Macros

How to Save Data from SAS Content to Workbench

How to Ensure Excel Uses Your SAS Formats for Number Cells

How to Create an ODS Excel Spreadsheet Over the Current Memory Limit

How to Sort in SAS Viya vs. HIVE

How To Use PROC FEDSQL

List of SAS Viya Global Macros

Loading Data into CASLIB is Slow

Where to Store Data/Files in SAS Viya

Job Monitoring in SAS Viya

Merging Different Datasets in SAS Viya

Applying Lengths & Formats on Large Data

SAS Viya is Slow - Trouble Shooting

SAS Viya Idle Session Timeout Issues

Ensuring Decimal Precision

Guidance on Joins

How to Execute on PostgreSQL and Write to SAS Datasets

Limit Table Size

SAS Viya Workbench Recovery Policies and Procedures

Use Integers for Matching

WHERE Statement When Filtering

Example Code Folder Within SAS Viya (SAS Content--> Example Code)

SAS Viya 3.5 Programming Documentation

SAS e-Learning Procedures

SAS Studio 5.2 User Guide

SAS Support Documentation

SAS Visual Analytics 8.5 Overview & Reference Links

How to Save CASLIB Files Before CCSQ D&A Maintenance Events

SAS Procedures Optimized for CAS

SAS Viya Supported Web Browsers

SAS Viya Training Videos

SAS Viya Upgrade

How to Save Zeppelin Notebooks

Zeppelin Execution Hooks

Zeppelin Overview


How to Create a Help Desk Ticket

Communication Call Material

Databricks CASLIB Connection Update: Context, Phases, & Timeline

FAQs

HiveQL Language Manual

How to Open a ServiceNow Ticket

Lustre Migration: Context, Phases, & Timeline

How to Create a Help Desk Ticket

Training & Onboarding Page

How to Add Additional Team Members to Filecloud

How to Utilize Workbench and Filecloud With SAS Viya