First, you need to gain access to the CoinMarketCap API. Sign up for an account on the CoinMarketCap website and navigate to the API section. Choose a plan that suits your needs and obtain an API key. This key will allow you to access the cryptocurrency data provided by CoinMarketCap programmatically.

Use Python to fetch the data from the CoinMarketCap API. Utilize the `requests` library to send GET requests to the API endpoints. For example, to fetch the latest market data, you might use:
```python
import requests

api_key = 'your_api_key'
url = 'https://pro-api.coinmarketcap.com/v1/cryptocurrency/listings/latest'
headers = {'X-CMC_PRO_API_KEY': api_key}
response = requests.get(url, headers=headers)
data = response.json()
```
Ensure that you handle any errors or exceptions that might occur during the API call.

Once you have fetched the data, process and clean it as necessary. This may involve selecting specific fields, renaming columns, and transforming data types to ensure compatibility with Starburst Galaxy. Use Python libraries like `pandas` to manipulate the data:
```python
import pandas as pd

df = pd.DataFrame(data['data']) # Assuming 'data' is the key in the JSON response containing the required information
# Perform any cleaning or transformation needed on df
```

Save the cleaned data to a local file in a format that Starburst Galaxy can read. Common formats include CSV or Parquet. For example, saving as a CSV can be done with:
```python
df.to_csv('coinmarketcap_data.csv', index=False)
```
Ensure the file is saved in a location accessible for the next step.

Set up your Starburst Galaxy environment if you haven't already. This involves creating an account, configuring your workspace, and ensuring you have the necessary permissions to load and query data.

Manually upload the saved CSV or Parquet file to Starburst Galaxy. This typically involves using the Starburst Galaxy web interface to import the file into a specified schema and table. Follow the on-screen instructions to complete the upload process.

Finally, verify that the data has been correctly imported into Starburst Galaxy by running some basic queries. Use Starburst Galaxy’s SQL interface to perform simple SELECT queries and ensure the data matches the expected structure and content:
```sql
SELECT * FROM your_schema.your_table LIMIT 10;
```
Check for any discrepancies and validate that the data is ready for analysis.

By following these steps, you can effectively transfer data from CoinMarketCap to Starburst Galaxy without relying on third-party connectors or integrations.